View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Conditional Format

Check if the dates in D are text


--
Regards,

Peo Sjoblom



"jk" wrote in message
...
I have one column that contains condtional formatting as the following:

=today()-D2=90

Should the field meet the above condition then the text would turn red as
the format but even though it was applied to the entire column, each date
imputted turns red regardless of the date. Can someone see what is wrong
on
this?