Auto colour change in cells?

[Beemer]

Can I have Excel automatically change the colour of cell data so that
entered data will be a differed colour from future days cells?

Beemer

 

[Norman Harker]

Hi Beemer!

Use

Select the range that contains your dates
Format > Conditional Formatting
Cell value is
Greater Than
=TODAY()
Format button
Select format
OK
OK

 

[Beemer]

Hi Beemer!

Use

Select the range that contains your dates
Format > Conditional Formatting
Cell value is
Greater Than
=TODAY()
Format button
Select format
OK
OK

Norman,

It works (of course!)

Thanks,

Beemer

 

[Norman Harker]

Hi Beemer!

Thanks for the confirmation. Not so much of the "of course" <vbg>