Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format help
Hi
I have a date in H4 where using conditional formatting, will flag green if its within 2 days of today, amber if 2-3 days of today and red if 3+ days from today however, i need the formatting to stop if there has been a date entered into I4 (as this will mean there is no need for the cell to flag to us that there is no data in I4 if that makes sense) can anyone help please? thanks Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |