Formatting text/formulas in sheet

  • Thread starter Thread starter Utkarsh
  • Start date Start date
U

Utkarsh

Hi
Is there any way in which I can ensure that if any cell contains a
formula the cell contents should appear in blue color; and the
hardcoded items in black. Thanks.
 
You need to create a UDF,like so

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

and use that UDF in conditional formatting, like so

=isformula(A22)
 
sorry didn't mean to post anything, see Bob's answer
several hour before in this thread.
 
Back
Top