Cells font colors

[Robbins2U]

Does anyone know how to have a cell font change color
What I am trying to figure out is if cell A1 contains a number I would like that cell font to start off in red and if cell B2 contains a number have cell A1 change to red automatically
I think it is something like =IF(D4="",0[RED],100[GREEN]

And/Or Should I use Condiational Formating or a double IF?

 

[Norman Harker]

Hi Robbins2U!

You can't do it with cell formulas.

Take a look at Format > Conditional formatting.

You need the Formula is option and your formula should evaluate to
TRUE or FALSE

 

[CLR]

There are a number of ways to cause the font in a cell to change
color..........Custom Formatting, Conditional Formatting, or through Macros,
to name some.........trying to do so with regular formulas is not one of
them.

First thing you need to decide is how many colors you want to use, and what
conditions you want each to exist under..............once you have that
list, post back and someone will help............can't do much with your
initial spec of "make A1 RED, then if a number in B1, make A1
RED"............

hth
Vaya con Dios,
Chuck, CABGx3

Does anyone know how to have a cell font change color?
What I am trying to figure out is if cell A1 contains a number I would

like that cell font to start off in red and if cell B2 contains a number
have cell A1 change to red automatically.

I think it is something like =IF(D4="",0[RED],100[GREEN])

And/Or Should I use Condiational Formating or a double IF?