Define a Range Name IsFormula =GET.CELL(48,INDIRECT(“rc”,FALSE)) Apply a conditional formatting cells testing for the formula, i.e. =IsFormula with a colour fill « Select cells based on color or formatting of another cell CONCATENATEIF function for Excel »