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

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).

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

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.

--
Biff
Microsoft Excel MVP


"marzomarz" wrote in message
...
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).