How do I use Conditinal Format for another cell?
in [Programming]
|
From: Nilou on 22 Feb 2010 11:30 Assuming Cell A1 is the value "Red" or "Green" or "Yellow" How could I have a formula on Cell "C1" containing Conditional formatin the same as below if A1 is "Red" then Bacground of A1 turns to red if A1 is "Blue" then Bacground of A1 turns to Blue if A1 is "Yellow" then Bacground of A1 turns to Yellow
From: Jim Thomlinson on 22 Feb 2010 13:17 I assume that your statement if A1 is "Red" then Bacground of A1 turns to red should be if A1 is "Red" then Bacground of C1 turns to red ??? Assuming that to be true Select C1 Format | Conditional Formatting Formula is = A1 = "Red" Set your Red format Ok Repeat for other colours. -- HTH... Jim Thomlinson "Nilou" wrote: > Assuming > > Cell A1 is the value "Red" or "Green" or "Yellow" > > How could I have a formula on Cell "C1" containing Conditional formatin the > same as below > > if A1 is "Red" then Bacground of A1 turns to red > if A1 is "Blue" then Bacground of A1 turns to Blue > if A1 is "Yellow" then Bacground of A1 turns to Yellow > >
|
Pages: 1 Prev: too many arguments error message in excel Next: Unprotecting cells using VBA |