If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cells with formulas a different color
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. |
#2
|
|||
|
|||
Cells with formulas a different color
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) -- __________________________________ HTH Bob "SDMFG" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|