rag

  1. M

    Rag rating

    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...
  2. R

    RAG Status using conditional format for 3 dates

    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...
  3. R

    RAG Status help!!

    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
  4. C

    Conditional formatting with dates using the RAG status

    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...
  5. M

    RAG Rating on Excel Graph

    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...
  6. F

    Conditional Formatting

    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...
  7. F

    Conditional format

    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
  8. R

    Conditional Formatting & YTD Calculation

    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...
  9. J

    Conditonal Format multiple RAG status column

    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% -...
  10. G

    Traffic Light RAG rating

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top