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 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
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.
