View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Busch[_2_] Mike Busch[_2_] is offline
external usenet poster
 
Posts: 16
Default Conditional format issue

In 2003 when I try to use a conditional format on a date field, I select the
field and set if for less than Now (). This will change the date to red when
a bill is past due. I am doing something wrong, because no matter what date
is there, all the date cells in this field turn red. What am I doing wrong.
Thanks in advance