Traffic Lights in Excel

[lopster10]

Hi Guys,

I am currently working on a traffic lights system for an excel spreadsheet.

I have 2 date columns and a colum to indicate the colour.

So Target Completion || Current Completion || Status


I see the logic as..

If target completion is in the future, colour is green.

If target completion has passed but the current completion hasnt, this would have an amber.

If target completion date passed and no current completion date then this would be red.

If both target and current completion have passed then this would be red as well.

As I understand it the conditional formatting only excepts 3 conidtions so it wouldnt be possible to use this? Is my only other option to use VBA? If so could anyone point me in the direction of an example?

Any help appreciated,

Regards,

Lopster

 

[AnotherHiggins]

Conditional Formatting allows you to set 3 conditions.

BUT

Cells that don't meet any of those conditions show the default formatting. So that's basically a total of 4 different conditions you can use.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[strongm]

That restriction was removed in Excel 2007