conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a CF for expiration dates, I am using the "cell value is" method
to determine if the date is expired, however, it is highlighting any blank
cell as well. Is there a way to prevent the hilighting of blank cells?
 
An empty cell formatted as a date equates to 01/00/00.

So, if your CF formula might look like this:

=A1<=Today()
Revise it to something like this:
=And(A1<>"",A1<=Today())
 
Back
Top