Link different conditional formatted rules to the selected text of another cell

Copper Contributor

Hi,

 

I have created 9 different conditional formatted rules for a column, however, I would like to select only 3 specific relevant rules based on the result of a text selected from a drop down in another cell.

 

So if the user selected text 'ABC' from a drop down this would only bring 3 specific conditional formatting rules into play for the cell on the same row as the text selection.

 

 

1 Reply

@slipstream 

You can disable the 6 other rules by adding a condition that the text in another  is not "ABC". 

The formula in your conditional format will be something like

=AND(A1<>"ABC", other conditions)

 

A1 is your selected cell.