Implementing RAG on Excel based on dates passed

Visitor

Hi, 

 

Im struggling to implement a red, amber, green system on Excel on a project for work (I have very limited Excel knowledge). 

 

The system relates to how long patients have been admitted to our service. If they been there 1-2 days = Green, 3-4 = Yellow and 5+=Red. 

 

The two columns I'm comparing Are "Arrival Date (C2:C8)" and "Anticipated Exit Date(D2:D8)" but am struggling to have the anticipated exit column display the relevant colours. 

 

Here's a screenshot of what the table looks like when filled out manually:

byron_day_1-1653400948887.png

 

Any help on how I might get the final column to assign a colour automatically on Excel would be greatly appreciated

1 Reply

@byron_day 

 

You can do this with conditional formatting - see attached sample.