conditional format (Highlight cell Yellow)

This process works, if you have any trouble send the document and I will insert the conditional formatting.
Select Insert, Name, Define.
In the Define Name dialog box, enter the following in the 'Names in workbook' box

CellHasFormula
Then enter the following formula in the "Refers to" box

=GET.CELL(48,INDIRECT("rc",FALSE))
Click Add, and then OK.
Select all the cells to which you want to apply the conditional formatting.
Select Format, Conditional Formatting
In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and then enter this formula in the adjacent box (see the figure below):

=CellHasFormula
Click the Format button and select the type of formatting you want for the cells that contain a formula.
Click OK.

After you've completed these steps, every cell that contains a formula and is within the range you selected in Step 4 will display the formatting of your choice.

I looked it up and ISFORMULA was introduced in 2013, so you won't have it in 2010. Therefore matt85webb has the right solution. Please let us know if you got that to work.

Four years from now, when you upgrade to 2013 , the function ISFORMULA can be used to create your CF formula like this:

=ISFORMULA(A1)

where A1 is the cell in the upper left corner of the range you want to format, change to suit. (Do that instead of what you showed in post #3 above.)

[editorial]Most organizations are not quick to adopt the latest version because there is usually not much economic motivation to do it. That's why a lot of vendors like Microsoft and Adobe are pushing into an online subscription-based model so that they can get your money continuously instead of every 5 years when there's really a benefit to upgrade.[/editorial]