rag

Trying to summarise the RAG status in one field but unsure how I do that Column D needs to make sure it groups Column A and then column B and then assign the lowest RAG from column C For example, For Workstream 1, 'Pilot' appears twice in column B with the lowest RAG status of Red. So Column D...

Afternoon... After some excel related inspiration if anyone is feeling in a giving mood? I need to RAG rate individual cells containing a list of people, places, processes and plans and this needs to be done/displayed in a visually pleasing way as this will be displayed in offices across the...

Hi I have a set of dates in A1, which are planned dates to complete works. I would like the cells in column B to highlight according to a RAG status. If the Dates in Column A1 is within 7days of Today(), the cell highlights red. If the Dates in Column A1 is within 7-21days of Today(), the...

Hi, Is there a nested if formula that can result in a RAG status for the following Criteria? R if less than 1.5 or more than 4 A if between 1.5 and 2 or between 3.5 and 4 G if between 2.1 and 3 Thanks

Good Day all I have been experiencing an issues with a very small spreadsheet, causing me a major headache. I have a set of key dates across columns M, N, O on row 4. M4= First Draft N4=Final O4= Mobilization/ Start Date First draft needs to be received 8 weeks prior to mobilization and final...

Hi All, I am having trouble adding a RAG rating to the right of an excel Graph. Is anyone able to help? https://www.guysandstthomas.nhs.uk/resources/about-us/board-minutes/2018-board-papers/february/board-of-directors-performance-report.pdf Something similar to Page 50 on the link above...

I have 5 columns, headed Q1, Q2, Q3, Q4 and RAG. I need the RAG column to change colour (Red, Amber, Green) based on entries. Q1 will be populated and no action is required in the RAG column. When a figure is entered in Q2, if Q2 = Q1 then RAG will be Amber. If Q2 > Q1 then RAG will be Red. If...

Hi I need some help please! I have 3 cells - A1 contains a value; B1 contains a value; and C1 is to be formatted with a RAG status colour. If(A1>B1) then C1 should be filled green If(A1=B1) then C1 should be filled amber If(A1 <B1) then C1 should be filled red

Need some help. Am applying conditional formatting based on RAG rating (Red, Amber & Green) data, and it is working, but when it comes to YTD, the conditional formatting doesnt work as expected. The conditional formatting based on colours for YTD uses the YTD calculation but I want it to use the...

I've been asked to add a separate column to a spreadsheet specifically to indicate RAG status. There are multiple options within the RAG alert system, though. I need column F to show Top, Strong, Good, Developing or Under, based on the values in column E, as follows: 5% or less = Top 6% -...

Hi, I would like to set up a report showing traffic light RAG rating for data in my table. I have a field within each record that contains the numbers 1, 2, 3, and 4. I would like to produce a query/report which counts the number of records showing 1's and 2s and displays the result as a...