rag status

  1. 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...
  2. E

    Conditional formatting

    I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...
  3. T

    Conditional Formatting 3 date frames with a RAG Status

    Hi All, I have a 'Planned Date' column (V) and I need to apply the following conditional formatting RAG status: Four weeks prior to date in column 'V' the date needs to be highlighted Green Between 3 and 2 weeks prior to date in column 'V' the date needs to be highlighted Amber 1 week or less...
  4. G

    Format Cell Color - Depending on the color or other cells (RAG status)

    Hi All, I've had a quick search and I have not returned any results for this. My issue is a simple one, but I cannot find a way to do it with conditional formatting in excel 2010. (not that I'm an expert!) I have a number of cells which I have conditionally formatted to be green, amber or red...
  5. S

    Rag Status excel 2010

    Hi all, I have a problem where I am trying to get the RAG status for some values, built into a macro that will perform conditional formatting based on >= values or <= value. the Conditions for both will be different. So I need the currentl value to be analysed in terms of two scenarios...
  6. I

    Compare 2 columns and highlight 3rd column

    Hi, I have the requirement of comparing 2 columns and highlighting 3rd column with the appropriate colour. I am using MS Excel 2003 version E.g Data set A1 - '01-Nov-2009' B1 - '10-Nov-2009' Action required Compare A1 & B1. If A1 is less than B1, set "Green colour" background in C1 column...

Watch MrExcel Video

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