Formatting text/formulas in sheet

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

 

[Bob Phillips]

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)

 

[David McRitchie]

--

 

[David McRitchie]

sorry didn't mean to post anything, see Bob's answer
several hour before in this thread.