Forum Discussion
Conditional Formatting based on Formula, Not Value
I have a workbook that uses several INDIRECT formulas. I would like to flag these via conditional formatting so I know which cells to update (i.e. a cell featuring any INDIRECT function turns red). ...
You may use conditional formatting rule with the formula
=ISNUMBER(SEARCH("INDIRECT",FORMULATEXT(A1)))assuming A1 is top left cell of your range