conditional formatting highlight the cell today's date

  • Thread starter Thread starter tegger
  • Start date Start date
T

tegger

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
 
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.
 
Back
Top