Forum Discussion

warrevar's avatar
warrevar
Brass Contributor
Aug 12, 2019

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

 

Any suggestions?  Thanks!

Excel Indirect Function Conditional Formatting

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 12, 2019

    warrevar 

    You may use conditional formatting rule with the formula

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

    assuming A1 is top left cell of your range

Resources