-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
rag status
-
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...- theguyIsHere
- Thread
- rag rag status
- Replies: 15
- Forum: Excel Questions
-
J
DAX Help - Latest Value
Hi I am looking for help with a DAX Measure. I have a list of milestones that might change each month. I am looking to do two things. - Return the latest status value of the milestone, - Count the number that match that status value, e.g.how many are now Green, Amber, etc. My data looks a...- johnny_doyle
- Thread
- count latest dax measure rag status
- Replies: 0
- Forum: Power Tools
-
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...- cda2212
- Thread
- conditional cell colour dates mobilization rag rag status
- Replies: 5
- Forum: Excel Questions
-
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...- edwardj3
- Thread
- condition formatting excel 2007 if/and formula rag status service
- Replies: 5
- Forum: Excel Questions
-
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...- Toodlelou
- Thread
- 3 dates conditional formatting rag status
- Replies: 13
- Forum: Excel Questions
-
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...- gusphol
- Thread
- conditional format excel rag status
- Replies: 1
- Forum: Excel Questions
-
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...- sanjay86
- Thread
- conditional format greater than or equal to if function lower than or equal to rag status
- Replies: 0
- Forum: Excel Questions
-
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...- ilasubbu
- Thread
- compare highlight rag status
- Replies: 4
- Forum: Excel Questions
