I am looking to apply conditional formatting to all the cells in my sheet and highlight cells that contain a formula. I know that I can format cells based on a custom formula, and I know that I can use the
ISFORMULA() function to determine a cell contains a formula.
e.g. I can apply conditional formatting to cell B7 using the custom formula
How do I format an entire range using this formula? I do not wish to manually type this formula for every cell.