Conditional Formatting - Color Codes

[moonoverparadise]

Hello,

I am working within an excel sheet that has some conditional formatting already in place.

There is a 3 separate cells that if you put the letter R in the cell, the cell turns Red
if you put the letter G in the cell, the cell turn Green.

Although, it does not show in the snippet I added to this question, that formatting has been working beautifully.

But on the bottom of the worksheet under Totals I need more conditional formatting, Under Totals (Tuesday cell) I want to take all three Red or Green Cells from (Tuesday) FMSW/FL/87th to calculate the color the total color. Hopefully that makes sense.

For example...if Cell B13 is Green, B31 is Green, and B47 is Red then B63 is Red
If cell B13 is Green, B31 is Green and B47 is Green then B63 is Green


[TABLE="width: 281"]
<tbody>[TR]
[TD="class: xl66, width: 222, bgcolor: yellow"]FMSW
[/TD]
[TD="class: xl87, width: 80, bgcolor: yellow"]Tue
[/TD]
[TD="class: xl87, width: 72, bgcolor: yellow"]Wed
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Situational Awareness
[/TD]
[TD="class: xl64"]if B13 is Green
[/TD]
[TD="class: xl64"]if B13 is Green
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Methods
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Equipment
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Supplies
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: transparent"]Staff
[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, bgcolor: #FFCC00"]Fishers Landing
[/TD]
[TD="class: xl90, bgcolor: #FFC000"]Tue
[/TD]
[TD="class: xl90, bgcolor: #FFC000"]Wed
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Situational Awareness
[/TD]
[TD="class: xl64"]if B31 Green
[/TD]
[TD="class: xl64"]if B31 Green
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Methods
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Equipment
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Supplies
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: transparent"]Staff
[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: #92D050"]87th Ave
[/TD]
[TD="class: xl92, bgcolor: #9BBB59"]Tue
[/TD]
[TD="class: xl92, bgcolor: #9BBB59"]Wed
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Situational Awareness
[/TD]
[TD="class: xl64"]if B47 is Red
[/TD]
[TD="class: xl64"]if B47 is Green
[/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Methods
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Equipment
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl84, bgcolor: transparent"]Supplies
[/TD]
[TD="class: xl64"][/TD]
[TD="class: xl64"][/TD]
[/TR]
[TR]
[TD="class: xl93, bgcolor: transparent"]Staff
[/TD]
[TD="class: xl77"][/TD]
[TD="class: xl77"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #00B0F0"]Totals
[/TD]
[TD="class: xl88, bgcolor: #00B0F0"]Tue
[/TD]
[TD="class: xl88, bgcolor: #00B0F0"]Wed
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Situational Awareness
[/TD]
[TD="class: xl64, bgcolor: transparent"]Then B63 is Red
[/TD]
[TD="class: xl64, bgcolor: transparent"]Then B63 is Green
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Methods
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Equipment
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Supplies
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Staff
[/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Select B63
CF > New Rule
1st rule
Try a formula in CF
=AND(B13="R",B31="R",B47="R")
Format --> Red

CF > New Rule
2nd rule
Try a formula in CF
=AND(B13="G",B31="G",B47="G")
Format --> Green

Hope this helps

M.