create cell formula for...

[Denys]

I'm trying to have a formula to change the color of a cell when a number is
type in.

ie., 1= red; 2=yellow; 3=blue, etc.

I've been looking all over, but to no avail.

I want the cell to change color if number 1 is typed in it, etc....

any help would be appreciated it.

Thanks in advance

Denys

 

[Biff]

Hi!

If you have more than 3 conditions then you'll either need VBA code or a
special add-in that's been designed for this.

Try this for the 3 conditions in your example:

Select the cell where you want this color to appear. I'll assume this is A1.

Goto Format>Conditional Formatting
Select Formula Is from the drop down list
Enter this formula in the box to the right: =A1=1
Click the format button
Select the style(s) desired
OK

Click the ADD button and repeat the above steps for your other conditions
changing the formula as appropriate. =A1=2, =A1=3

If you have more than 3 conditions then you might be interested in this
add-in:

http://www.xldynamic.com/source/xld.CFPlus.Download.html

Biff

 

[Gord Dibben]

Formulas cannot format cells, only return values.

Check out Format>Conditional Formatting.

You can have 3 conditions..........4 if you count the default.

If etc. means more than that, you will probably need VBA code or visit John
McGimpsey's site for Custom formatting up to 6 colors for numbers.

http://www.mcgimpsey.com/excel/conditional6.html


Gord Dibben MS Excel MVP

 

[Denys]

Thank you Biff and Gord.
it works. this is what I wanted to do.

Denys

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thank you Biff and Gord.
it works. this is what I wanted to do.

Denys