Format all cells containing formulas

[darrylyu]

I'd like all cells which contain calculated values to show up in
different color (or some other formatting change). I know I can toggl
formula fields to be visible and manually update each one individually
but I'd ideally like something that automatically formats new formul
cells (and even applies to new .XLSs and worksheets). Seems like a
obvious thing to want to do, but haven't found this anywhere in th
UI.

A usable fallback option would be a macro to search the worksheet an
apply (eg) Red Bold to every cell containing a formula.

Any pointers?
Thanks,
-

 

[JE McGimpsey]

One way:

Enter this UDF in a regular code module (in the VBE: Insert/Module):

Function IsFormula(rCell As Range) As Boolean
IsFormula = rCell.HasFormula
End Function

In XL, select your used range, with A1 the active cell, then choose
Format/Conditional Formatting:

CF1: Formula Is =IsFormula(A1)
Format: Bold, Red