I have been using conditional formatting to make a cell change colors if a)greater than or b)less than, today's date; however, I don't know how to tell excell to leave everything as it is when there is no information logged in the reference cell.
A C D
3 DATE EVENT
4 1mar11 red
5 1Jun12 Green
6 Blank (still changes color)???
I want D6 to stay without formatting when C6 has no date in it. Thanks,