Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting formulas
How do I use the "if" function referring to an adjacent cell in "conditional
formatting" eg. I want a cell to turn yellow when the vallue in the adjacent cell =0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting formulas
No need for IF, you just need an expression that evaluates to TRUE or FALSE
I selected D1:D20 and entered the conditional format: Formula IS: =C1=0 and set the pattern to yellow. The cells in D1:D20 are now yellow filled if the corresponding C cell is zero or blank. If I want yellow when there is a zero in adjacent cell but not when it is blank then I use =AND(NOT(ISBLANK(C1)),C1=0) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kobus" wrote in message ... How do I use the "if" function referring to an adjacent cell in "conditional formatting" eg. I want a cell to turn yellow when the vallue in the adjacent cell =0 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting formulas
Thanks it help
"Bernard Liengme" wrote: No need for IF, you just need an expression that evaluates to TRUE or FALSE I selected D1:D20 and entered the conditional format: Formula IS: =C1=0 and set the pattern to yellow. The cells in D1:D20 are now yellow filled if the corresponding C cell is zero or blank. If I want yellow when there is a zero in adjacent cell but not when it is blank then I use =AND(NOT(ISBLANK(C1)),C1=0) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Kobus" wrote in message ... How do I use the "if" function referring to an adjacent cell in "conditional formatting" eg. I want a cell to turn yellow when the vallue in the adjacent cell =0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) |