You need to add a user defined function to the workbook.

Enter this in a module:

Public Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function

Then highlight the cells needing CF, go to Conditional Formatting,
choose "Formula Is" and type in the formula field:

=IsFormula(A1)

....and set your desired format.

(Change A1 in the formula to the upper-left cell of the range you
highlighted.)

Mark Lincoln


On Aug 24, 2:40 pm, Finny388 wrote:
I cannot figure this out no matter what I do
Every formula it try to apply addresses the RESULT of the formula (as
it should) instead of the value.

any solution much appreciated

thanks