Aug 12 2019 12:58 PM
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!
Aug 12 2019 01:16 PM
You may use conditional formatting rule with the formula
=ISNUMBER(SEARCH("INDIRECT",FORMULATEXT(A1)))
assuming A1 is top left cell of your range