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

Some videos you may like

This Week's Hot Topics