View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Linda RQ[_2_] Linda RQ[_2_] is offline
external usenet poster
 
Posts: 30
Default conditional formatting

Excel 2003. Beginner user here. I have Cell C3 with a date and time. I
have Cell D3 with a date and time. I want Cell C3 to become bold text if
the date only is the same as the date in cell C3.

C3 12/1/09 08:20 (bold text because the date is equal)
D3 12/1/09 13:20

I tried using conditional formatting but only the dates and times that are
exactly the same are bold. I need the conditional formatting to ignore the
time.

Thanks,
Linda