Setting Expiry Date

**Lewis Koh** · 02-09-2010, 10:10 PM

Hi,

I want to set a future date in a cell and if today() is over this stated date, the cell will turn red.

Example

A1 = 11/2/10

Today() = 10/2/10

I try to set condition as If Cell value A1 >= Today(), shade cell as red.

I couldn't get this right. What else do I need to tweak to make it work?

Regards,
Lewis

**teylyn** · 02-09-2010, 10:53 PM

Hi Lewis,

try Conditional format with Formula is

=A1>=TODAY()

hth

**Lewis Koh** · 02-09-2010, 11:23 PM

Hmm...weird, it works only if I do

=A1<=TODAY()

Why is that so?

**teylyn** · 02-09-2010, 11:51 PM

sorry, my bad. hit the wrong key. But the essence was to use Formula Is rather than Cell Value Is

So if Today is greater than or equal to A1, or A1 is less than or equal to Today

=A1<=TODAY()

or

=today()>=A1