Dates With Color

[gymwrecker]

How could I make the data of certain cells change color when a specific date arrives?
For example, A1 has 20 May 02, how could I make that cell change to red when it is actually 20 May 02 or later?

Thanks!

[Nimrod]

[s-o-s]

On 2002-05-14 13:42, gymwrecker wrote:
How could I make the data of certain cells change color when a specific date arrives?
For example, A1 has 20 May 02, how could I make that cell change to red when it is actually 20 May 02 or later?

Thanks!

Format / Conditional Formatting /

In the msgbox Click the 2nd drop to read greater than or equal to

In the next box enter the date in question 20/05/02

Next click the formating button and select a red background

Click OK twice.

[Brian from Maui]

Gym,

Not sure if data will always be date, if it is you can try using this with conditional formatting
=a1>=today()

[Nimrod]

-toolbar
--format
---Conditional Formating
----select cell value is on drop down
-----enter dates in same format as will be in cells
------use format option in conditional window to select color

[gymwrecker]

Everything worked perfectly, but need a little help on something:

Path:
Format/Conditional Formating/
After I type "less than or equal to", what should go in the range is todays date, not a specific date from a cell; I explain, once a date reaches todays date, it should turn red.
Please advise.

Thanks!

[gymwrecker]

Thanks to all!! My formula is 100% working!