conditional formatting
Thank you to all of you!!! It works great now!!!!
"Ragdyer" wrote:
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())
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
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?
|