You need to use conditional formatting for that. Format - Conditional Format
| Formula Is ...

--
HTH...

Jim Thomlinson


"tina" wrote:

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