Sep 02 2019 01:31 AM
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.
Sep 02 2019 05:10 AM
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.