rag rating

  1. S

    RAG rating with percentages

    Hi Guys, Just keep stumbling on this one - I'm trying to do a RAG rating with multiple cells and rules. There are percentages in columns B,C,D,E. Now the rule that I would like to set is that if the value in column B is < 50% then the number I should see in column F should be 2 and if over...
  2. T

    Working out RAG status based on 3 columns

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

    VBA to turn part of text in cell red if negative

    I have a column that the user wishes to have a simple calculation (H11-M11) as well as having a % in the same cell. Formula is ::: =(H11-M11)&" / "&TEXT(H11/M11,"0%") If the first part is negative, I wish for it to be RED. If not, then GREEN. Does someone know of a code that allows this...
  4. A

    Hide rows in Excel 2010 based on conditional formatting iconsets

    Hi, I wonder if anyone can help me with this. I do not know VBA code. I am fairly ok with using excel. I have a large spreadsheet and I have various sets of records in the spreadsheet coming in from different sources. They are all RAG rated. I now want to hide all the records that are RAG rated...
    • aec
    • Thread
    • conditional formatting icon sets rag rating
    • Replies: 5
    • Forum: Excel Questions

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
Back
Top