Hi,
I'm working for an employer who's still using Excel 2003 (I know, I know) so I wonder if anyone can help me with some code for conditional formatting. Here's the scenario:
Column M calculates a risk impact score based on a number of other columns. The conditional formatting is set up to change the cell to red if the score is greater than 14, amber if it's from 4 to 13, and green if it's less than 4 but greater than zero. So far so good.
Column P indicates whether the risk is Open or Closed. The RAG conditions in column M should be over-ridden and the cell changed to grey if the risk is "Closed".
I've found lots of VB code for handling 4+ conditions but I don't know how to bring column M into the equation, and I also don't know how to go about making the open/closed condition take precedence over the impact score.
As an added curiosity -- currently I'm greying out the rest of the line for closed risks using a simple forumla in conditional formatting, and for reasons I can't fathom the cell colour in column M is changing to blue. There doesn't seem to be any other code that should be affecting it.
Little help?
Bookmarks