Forum Discussion
color the cells of a specific column based on the values of other columns
=AND(E2="yes",F2="yes",G2="yes")Maybe with this rule for conditional formatting. Each color requires a different rule for conditional formatting.
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).
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.