Forum Discussion
color the cells of a specific column based on the values of other columns
Hello all,
Could someone help me realize this:
I'm trying to color the cells of a specific column based on the values of three other columns.
So the three cells of the three columns contain 'yes' or 'no' values and based of the combination of these 3 values a color is chosen for the cell of another column.
Thank you in advance.
=AND(E2="yes",F2="yes",G2="yes")Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.
6 Replies
=AND(E2="yes",F2="yes",G2="yes")Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.
- Thank you, but doesn't the '2' in 'E2' refer to a specific row in Excel? I want the formatting to apply on the value of a column (in your case 'H') for EACH row (so 1,2,3,4...). Could you help me with that? Or is this rule indeed correct for my case?
This is the rule for yellow color in my example.
=AND($E$1="yes",$F$1="yes",$G$1="yes")Perhaps i misunderstood what you want to do. Does this return your expected result? With this formula you can highlight all rows of a column if "yes" is entered in cells E1, F1 and G1. Every color requires a different rule for conditional formatting.
This is the rule for green color in my example.
=AND($E$1="yes",$F$1="yes",$G$1="no")
