Conditionally format a cell if it contains a formula


  1. Define a Range Name IsFormula =GET.CELL(48,INDIRECT(“rc”,FALSE))
  2. Apply a conditional formatting cells testing for the formula, i.e. =IsFormula with a colour fill