Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
THANKS A BUNCH. THIS FORMULA WORKED PERFECT. YOU ARE A LIFE SAVER.
"DOR" wrote: Use the following conditions: =G3F3 --red =G3=F3) --yellow =AND(G3<"",G3<F3) --green You might also use data validation on the date fields to ensure that only dates are entered in them ... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date conditioning format problem | Excel Discussion (Misc queries) | |||
help with cell conditioning? | Excel Worksheet Functions |