I have a column that uses dropdowns for the user to select values. Depending on which value is selected, I want it to conditionally format other cells in that same row.
Here's an example of my sheet:
When a cell in the
Dropdown column has the value "Selection One" I want cells in that same row highlighted in the
Description column. When a cell in the
Dropdown column has the value "Selection Two" I want cells in that same row highlighted in the "Size" and "Description" column, and if the
Dropdown column has the value "Selection Three" I want the cells in the
Size columns highlighted. Here's what I'd ultimately like it to appear:
I've tried various formulas, and the best I've been able to accomplish is formatting all cells in certain columns if any cell in the
Dropdown column has, for example "Selection one", which obviously doesn't accomplish what I'm trying to do.