Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting formula question
Using conditional formatting, what would the formula be if cell A2 was to be
highlighted red if empty but only if cell A1 contained data? Its a Monday and my head hurts! Any suggestions would be great! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting formula question
In conditional formatting for A2, choose Formula Is and use this formula
=AND(A1<0,A2=0) "Simon" wrote: Using conditional formatting, what would the formula be if cell A2 was to be highlighted red if empty but only if cell A1 contained data? Its a Monday and my head hurts! Any suggestions would be great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough conditional formatting question | Excel Discussion (Misc queries) | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting based on another cells formula result | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Worksheet Functions |