highlight or format cells with formulas

[Granny_Ruth]

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 containing "=" as I thought that would identify the ones with formulas in, but it doesn't work. Then I tried highlighting them, but that didn't work either - help!

[#2]

I also tried to find and replace with a bold format but that didn't work either....

[#3 · Accepted solution]

@Granny_Ruth 

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.

[#4]

@Granny_Ruth 

Excel Mac >/= 2011 & Excel Windows >/=2013 have function ISFORMULA

With Conditional Formatting:

[#5]

Thank you, Hans -that did it, just as I wanted!

[#6]

Thank you -I have already sorted it out using Hans' post, but thanks for replying!

[#7]

@Granny_Ruth 

Glad we could help & Thanks for providing feedback