View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marzomarz marzomarz is offline
external usenet poster
 
Posts: 1
Default 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).