Forum Discussion
Solved
highlight or format cells with formulas
I can't see quite this question on the forum, apologies if I've missed it! I want to format every cell in the worksheet that contains a formula. I tried to make a conditional rule for every cell con...
Select the entire range.
In the following I will assume that A1 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=ISTEXT(FORMULATEXT(A1))
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Select the entire range.
In the following I will assume that A1 is the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ISTEXT(FORMULATEXT(A1))
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Thank you, Hans -that did it, just as I wanted!