Cells with formulas a different color

S

SDMFG

Is there a way to make fonts of cells with formulas a different color? For
example, if a number is hard keyed, it would be black, but if the number was
the result of a formula, it would be blue? I dont want to see the formula
(formula auditing) or see arrows (trace dependents) - I want to see the
number, but be able to see if it is the result of a formula, based on its
color. Is there an option such as this in excel? I am using 2007. Thanks.
 
B

Bob Phillips

Add this UDF

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


and use as the formula in conditional formatting, such as

=IsFormula(A2)
 

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

Similar Threads

Excel VBA 1
Excel Use COUNTIF across a range of cells with formulas 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Mid column sum formulas with varied ranges to sum 17
Fastest ways to trace formulas (especially when cells link to otherworksheets) 4
How do you ID cell precendents/dependents in other sheets? 2
Excel Wildcard in Excel array formula 0
Excel Numbering rows by font color, but skipping blanks 1

Top