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

Some videos you may like

This Week's Hot Topics