| 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 | |||
Hybrid Mode
