Traffic light Formula not working

**TonydeBurgh** · 06-15-2013, 01:56 PM

Im trying to generate a formula in Excel 2007 that will allow me to implement a 'traffic light' system for dates on a training document at work. I need to have the cells that contain dates in the following parameters: -
less than 9 months old stay green,
9-12 months go yellow,
12+ go red.
I am aware of the now function, but is there an easier way as currently I have to add 3 layers per column in conditional formatting.

I hope there is!

Thanks in advance..............

**popipipo** · 06-15-2013, 01:57 PM

Please change the title of you question.
With this title we may not response on your question (forum rules!)

**popipipo** · 06-15-2013, 02:06 PM

is there an easier way as currently

Post your current and we can if it can or not

**TonydeBurgh** · 06-15-2013, 02:08 PM

Im using NOW function and minusing days and adding format to highlight cell.

i.e =now()-180 then choosing colour.

Is there something I can use which will save me having to put three layers on per column?

**popipipo** · 06-15-2013, 02:17 PM

For 3 colors you need 3 formula's
Each formula can do several columns
For your whole sheet you need only 3 formulas
Maybe een xls file will help

**aydeegee** · 06-16-2013, 03:57 AM

Hi TonydeBurgh

It is not clear whether you are using conditional formatting?

As popipipo says, if you post a sample of what you have, people will be able to see if they can suggest something better.
To post a file go to Reply and then Go Advanced where you can attach a file (all sensitive information removed!).

Regards
Alastair