2

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:

Example sheet

When a cell in the Dropdown column has the value "Selection One" I want cells in that same row highlighted in the Color and 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 Color and Size columns highlighted. Here's what I'd ultimately like it to appear:

enter image description here

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.

  • Can you clarify exactly what you've tried? Also, why isn't C2 highlighted? – Scott Sep 14 '17 at 1:45
3
  • For B2 and below, =OR($A2="Selection One",$A2="Selection Three").
  • For C2 and below, =OR($A2="Selection Two",$A2="Selection Three").
  • For D2 and below, =OR($A2="Selection One",$A2="Selection Two").

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.