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

  • Thread starter Thread starter marzomarz
  • Start date Start date
M

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).
 
I want to highlight several rows and this requires me to
do the conditional formating as formula=formula(cell ref).
Click to expand...

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.
 
Back
Top