Forum Discussion
Link different conditional formatted rules to the selected text of another cell
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 ...
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.