Changing Color

  • Thread starter Thread starter Frank West
  • Start date Start date
F

Frank West

Hi,

Is there a way to change the color of the font in a cell.

For ex.

A
1 red
2 black
3 blue
4 red
5 blue
6 red

In cell A2 can you enter something such as,
=if(a1=red,?,if(a1=black,?,if(a1=blue,?)))

I want cell A1 to turn red when I type in red and A2 to turn black
when I type in black, etc.

I only have three or four colors I need to work with.

Does each color have a corresponding number? How do you find those
numbers?

Thanks,

Frank
 
Look at Format=>Conditional Formatting

You can't do it with a formula in a cell.

Coditional formatting support 3 conditions. So you can set 3 colors, plus
the default color. Colors are selected from the palette, so there are no
numbers used such as you illustrate.
 
Look at Format=>Conditional Formatting

You can't do it with a formula in a cell.

Coditional formatting support 3 conditions. So you can set 3 colors, plus
the default color. Colors are selected from the palette, so there are no
numbers used such as you illustrate.
Click to expand...

That worked perfectly, thanks a lot.

Frank
 
Back
Top