Forum Discussion
Megan Cooper
Oct 12, 2018Copper Contributor
Exceptions within conditional formatting
I have an excel table listing various data formats. I applied conditional formatting to cells, based on the row, so that cells that are greater than or equal to a certain value are highlighted. My pr...
BobOrrell
Oct 12, 2018Iron Contributor
One method would be to select the column that you want excluded, and create a new rule using the formula =ISTEXT(C3), where C3 is the first cell of your selection, and don't change any of the formatting. Then, in the Conditional Formatting Rules Manager, ensure that it is listed first, and check the box that says Stop If True. This formula will stop for any text, but if you want it to not highlight for the specific terms, you could use the formula =OR(C3="ND",C3="Non-Detect")