formating a cell with a conditional if statement

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I'd like to write an if statement that would compare a
date to todays's date and if the date is before today's
date color the cell red and if after today's date color
the cell green. Any suggestions on how to write the if
statement?
 
Create a defined name (Ínsert/Name/Define)

Let it refere to a formula like this Today() name it ThisDay

Then create a conditional formating saying

Cell value / Less then / =Thisday

Wendel
 
Back
Top