Conditional Formatting based on Formula, Not Value

Brass Contributor

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

 

Any suggestions?  Thanks!

1 Reply

@warrevar 

You may use conditional formatting rule with the formula

=ISNUMBER(SEARCH("INDIRECT",FORMULATEXT(A1)))

assuming A1 is top left cell of your range