View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jk jk is offline
external usenet poster
 
Posts: 109
Default Conditional Format

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?