View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default conditional formatting

Can't believe the coincidence!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Teethless mama" wrote in message
...
Conditional Formatting

=AND($A1<"",$A1<=TODAY())


"ked" wrote:

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?