SOLVED

Conditional formatting traffic lights date and text

New Contributor

Elitebook/ Windows 10

Microsoft 365 Apps for enterprise

Excel Version 2008

 

I'd like to create a traffic light/ RAG for the attached worksheet:

1. Green = when Column A and Column C are both have entries i.e Date and Complete or Complete - date

2. Amber = when Column A has an entry and Column C is blank i.e Date is < 5 working dates of current date

3. Red = when Column A exceeds the current date and Column C is blank

3 Replies

@Felicity2021 

See the attached version. I used a formula in column D.

@Hans Vogelaar 

Thank you.

 

Will you break the formula down so that I can include it within Column A and be able to use it as a basic RAG to highlight the cells.

best response confirmed by Felicity2021 (New Contributor)
Solution

@Felicity2021 

See the attached version.