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

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



thanks,

tegger

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

thanks

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

Regards,

H.G. Lamy

"tegger" schrieb im Newsbeitrag
...
thanks

You could try using the formula:

=(C2=Today())

Assuming you are formatting cell C2
GB

"hglamy" wrote in message
...
Doesn't work with me in XL XP ?
Any idea what goes wrong ?

Regards,

H.G. Lamy

"tegger" schrieb im Newsbeitrag
...
thanks

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.

--
Regards,
Tom Ogilvy

"hglamy" wrote in message
...
Doesn't work with me in XL XP ?
Any idea what goes wrong ?

Regards,

H.G. Lamy

"tegger" schrieb im Newsbeitrag
...
thanks