On Aug 30, 11:28 am, Mark Lincoln wrote:
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

Thank you so much! That has been an issue for so long.

Thanks!