Auto colour change in cells?

  • Thread starter Thread starter Beemer
  • Start date Start date
B

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
 
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
 
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
Click to expand...
Norman,

It works (of course!)

Thanks,

Beemer
 
Back
Top