Apr 22 2021 08:02 AM
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
Apr 22 2021 08:26 AM
See the attached version. I used a formula in column D.
Apr 23 2021 12:21 AM
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.
Apr 23 2021 01:24 AM
SolutionSee the attached version.
Apr 23 2021 01:24 AM
Solution