My IF/THEN looks like this:

-- =IF('Data Input'!BC1470,'Data Input'!BC147,'GAAP details'!AY156*'GAAP
details'!AY151)

As you can see, it references another worksheet within the file. The
Conditional Formatting says I cannot use an outside worksheet as a criteria
for the conditional formatting - BUMMER!!! :-(

Any other thoughts???

tina


"David Biddulph" wrote:

Look up "conditional formatting" in Excel help.

The process for changing the font colour is done by conditional formatting,
whereas putting the number in the cell is done by a normal formula. You can
use the same condition under "formula is" is conditional formatting as you
used in your condition in your IF formula.
--
David Biddulph

"tina" wrote in message
...
Is it possible that, within an IF/THEN statement, I could say IF x is
true,
then "pull the number from specified worksheet and change the font color
to
(for example) blue."
--
tina