EXCEL - Conditional Formatting Question

[scliollio]

Hey guys, I'm working on a criticality-index of sort for work and can't quite seem to get it to format based on my desired conditions.

So using the below graph for reference, I have different factors (columns A-D) scaled 1-8 based on criticality. Then I have a TOTAL column (E) which is just a summation of it's row. I would like column E to be color scaled based on given ranges (not a heat map, need specific colors). If 10-12, Blue; 13-15, Green; 16-17, Orange, >17, Red. I can get that part. Now here is where I am running into issues; in addition to the previous formatting conditions, I also want column E to format to Dark Red and Bold if any of the numbers within it's respective row are an 8 (so my 2nd and 4th row should be Dark Red and Bold). If they do not contain an 8 (columns 3 and 5) then leave them formatted in their respective color ranges as defined previously.

I hope that made sense; any help would be greatly appreciated!! Thanks!
-Steve

A	B	C	D	E (TOTAL)
2	5	3	8	18
1	2	5	7	15
2	1	8	1	12
3	3	4	6	16

<tbody>
</tbody>

 

[arthurbr]

Just add a CF condition for 8 before the other conditions ( like = COUNTIF($A1:$D1,8) ) and in the CF Rules manager check " stop if true" box that you find at the end of this condition

 

[scliollio]

Just add a CF condition for 8 before the other conditions ( like = COUNTIF($A1:$D1,8) ) and in the CF Rules manager check " stop if true" box that you find at the end of this condition

Ahh of course... thank you very much!!