View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default conditional formatting

Use formula is instead,

=AND(A2<"",A2--"02/10/06")

as an example



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"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?