Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use Conditinal Format for another cell?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use Conditinal Format for another cell?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditinal Formatting | New Users to Excel | |||
Conditinal Formation | Excel Worksheet Functions | |||
Conditinal Format | Excel Worksheet Functions | |||
conditinal format that gives particular shape and color in cell | Excel Discussion (Misc queries) | |||
Conditinal format of cells within a worksheet + woorkbook | Excel Programming |