Conditional Formating and Dates

  • Thread starter Thread starter Kardon Coupé {Aka Paul}
  • Start date Start date
K

Kardon Coupé {Aka Paul}

How can I conditional format, so that if the day hasn't passed, the colour
of the cell is Orange, if the day has passed it is Red, and if the day is
today it is Green? (All mentioned cells with contain a date)

Can it be done, thanks.
 
Use the three format conditions. In the Conditional Format
dialog, change "Cell Value Is" to "Formula Is" and use the
following three formulas:

' orange
=$A$1<TODAY()

' green
=$A$1=TODAY()

' red
=$A$1>TODAY()

Change $A$1 to the appropriate cell reference.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I have just tried that, and it didn't work? I did it word for word, with the
exception of changing cell reference. and they all stayed the first colour I
chose, irrespective of the date I in the cell, or the date on the system
clock.
 
Hi Kardon!

I think you need the following conditional format entries for the
cells containing the dates

In the conditional format dialog

Cell value is
Less than
=TODAY()

Cell value is
Equal to
=TODAY()

Cell value is
Greater than
=TODAY()


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top