Conditional formatting and Graph question

[dipsydoodle]

Hi

I have a tricky problem (to me anyway); I’m looking for help as I am completely stuck .

PROBLEM 1

I have an excel data table, with numbers which correspond to either N/A, Low, Medium or High. The N/A, Low etc are all colour coordinated. I was wondering I have a box at the bottom has the total sum of all the numbers, would it be possible to colour co-ordinate this to correspond to IF low, Medium or High is most dominant? Rather than doing this by hand.

I’ve shown a basic representation of the table I use (without the lines as i couldnt figure it out on here) as it might be less complicated that way (the boxes on excel are highlighted rather than the words).

4 Low
12 Medium
20 High
SUM 36

PROBLEM 2

At the end, once the Sum has been calculated this then automatically goes into a graph, there are up to 10 bars on the graph, is it also possible to colour co-ordinate each different column on the graph to correspond to the colour of the sum box (if problem one is possible to do)?

Thank you so much

[VBA Noob]

Sorry davesexcel,

I just edit the title and moved to general.

dipsydoodle,

Please do read the forum rules below. Take a look at Conditional formatting for the first problem then I suggest you re post in charting for the 2nd question

http://www.contextures.com/xlCondFormat01.html

VBA Noob

[olasa]

There is something called Conditional Formatting.
It can change the cell color based on the number in the cell. Follow the link to see a video.

The second question. I would make a separate post in the Chart section - to get a quicker/better response.
Ask for help with something like Conditional chart color.

HTH
Ola

[dipsydoodle]

Ok just focusing on problem one here, forgetting two for the time being.

I have conditional formatted my table so that the low, medium and high cells are highlighted. I am trying to figure out how to get the sum column to correspond to a colour depending on whether, there are any "high" values which need to be highlighted, if there are no high then "medium" problems. I can't conditional format the Sum column to change colour with number as the number is irrelevant really, its the high, medium or low bit which will determine the final colour.

I can do it by hand so it isn't the end of the world, it would just be easier to have a macro or something which states this.

[olasa]

I'm not sure I understand, but as I read it:

"I am trying to figure out how to get the sum column to correspond to a colour depending on whether, there are any "high" values which need to be highlighted, if there are no high then "medium" problems. I can't conditional format the Sum column to change colour with number as the number is irrelevant really, its the high, medium or low bit which will determine the final colour."

'Find highest Alert level text in the list' and return that text next to the sum (Conditionally formatted)

This formula can return the highest alert level from a range: =IF(ISNUMBER(MATCH("High",$A$1:$A$10,0)),"High",IF(ISNUMBER(MATCH("Medium",$A$1:$A$10,0)),"Medium",IF(ISNUMBER(MATCH("Low",$A$1:$A$10,0)),"Low","")))
And the Conditional formatting - as I understand - you already have a grip on.

HTH
Ola