how to conditional format a cell if the cell contains a formula (U

[marzomarz]

I've used this UDF:

Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function


but I want to highlight several rows and this requires me to do the
conditional formating as formula=formula(cell ref).

 

[T. Valko]

I want to highlight several rows and this requires me to

do the conditional formating as formula=formula(cell ref).

I interpret that to mean you use the Formula Is option in conditional
formatting. So the correct formula would be:

=IsFormula(cell_ref)

Replacing cell_ref with the appropriate cell address.