View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB[_3_] GB[_3_] is offline
external usenet poster
 
Posts: 70
Default conditional formatting highlight the cell today's date

Yes - use conditional formatting.

Left box - select Cell value is
Middle box - select equal to
Right box - enter = Today()

Then select your format

GB

"tegger" wrote in message
...
The range("B2:H2") contains dates.

Can I use conditional formatting to highlight the cell which contains

today'
s date?



thanks,

tegger