"qwopzxnm" wrote:
> I was wondering if there's a way to change the text color in a cell
> that contains a formula.
> My goal is to build a financial model with cells that have blue text
> for cells with formulas, and regular black text for hard coded numbers.
> This will allow the users to easily identify which numbers can be
> adjusted, and which are coming from a formula.

Press F5 > Special > Check "Formulas" > OK
will select all formula cells on the sheet at one go
Then we could apply Format > Cells > Font tab (to taste)

Similarly, we could also select the constants:
Press F5 > Special > Check "Constants" > OK
then format ...

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---