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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top