Forum Discussion
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...
Probably a little late, but this is what I found to work around it.
=IF(AND(ISERROR(SEARCH("ND",D11)),D11>=D$9),TRUE,FALSE)
Where D11 is my cell value for a sample/analyte and D$9 is the cell listing my RSK or MCL. A lot of frustration went in to figuring it out, so I hope it helps someone.