Forum Discussion
Solved
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 'ye...
=AND(E2="yes",F2="yes",G2="yes")Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.
=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")- Thank you for the response! I think you misunderstood my question. So what I want to do is color the rows of a column, let's say H, based on the values of the columns E, F and G (in your example) OF THAT ROW.
SO:
yes yes yes => yellow in that row
yes yes no => green in that row
So more like your previous answer, but I do not want to specify any row-numbers since I do not know for sure that row 59 will contain 'yes yes yes' or 'no no no' or ...
But in your answer I saw 'E2' which means you are specifying the second row? I do not want to specify any rows in my formula. Sorry I am very new to conditional formatting so it could be that your formula is perfect but I do not know how to use it correctly.
