Hi,
use conditional formating entering the formula as follow. I assume that in
K2 you have a date
=today()-K2=90 choose color amber
=today()-k2<90 choose color red

"Vikki" wrote:

I am trying to create a traffic light formula in excel 2003. I want a cell B2
at the beginning of my spreadsheet to be green, if the date in cell K2 is a
minimum of 3 months away, amber if it is less than 3 months away and red if
it equal to or the expiry date.

Hoping you can help!

Vikki