conditional formatting highlight the cell today's date

[tegger]

The range("B2:H2") contains dates.

Can I use conditional formatting to highlight the cell which contains today'
s date?



thanks,

tegger

 

[GB]

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]

thanks

 

[hglamy]

Doesn't work with me in XL XP ?
Any idea what goes wrong ?

Regards,

H.G. Lamy

 

[GB]

You could try using the formula:

=(C2=Today())

Assuming you are formatting cell C2
GB

 

[Tom Ogilvy]

You could have a time value as well in the cell.

If you format the cell as general, does it contain an integer like 37910
or does it contain a decimal as well such as 37910.25

The test described tests if it contains 37910 and would fail if it contained
37910.25

37910 is the date serial number stored for Oct 16, 2003

It is like testing if
=Today()=Now()

They would only be equal at midnight.