Aug 22 2022 01:17 AM - edited Aug 22 2022 01:18 AM
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.
Aug 22 2022 01:34 AM
Solution=AND(E2="yes",F2="yes",G2="yes")
Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.
Aug 22 2022 01:58 AM
Aug 22 2022 02:23 AM
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")
Aug 22 2022 02:50 AM
Aug 22 2022 03:18 AM
My first suggestion should do what you are looking for. You can lock (specify) rows and / or columns with the $ sign. For example this =$E$1 would lock both column E and row 1. This =$E1 would only lock column E.
This rule for conditional formatting doesn't specify (lock) any rows and columns and returns the expected result.
=AND(E1="yes",F1="yes",G1="yes")
In the attached file you can enter any combination of yes and no in columns E, F and G in any rows. Column H then is formatted according to the formatting rule (if there is a rule for this combination).
Aug 22 2022 04:53 AM
Thank you! It was not working because the online (latest?) version apparently requires a semicolon and not a comma for separation, so I was actually writing a slightly other formula.
Aug 22 2022 01:34 AM
Solution=AND(E2="yes",F2="yes",G2="yes")
Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.