Solved How do I use an excel 2010 formula to change to color of a c

March 28, 2012 at 07:54:02
Specs: Windows XP
if a cell value is 3, I want to automatically change the adjacent cell color to red.
If a cell value is 2, I want to automatically change the adjacent cell color to orannge.
If a cell value is 1, I want to automztically change the adjacent cell color to blue.

My question is what formula to I use?


See More: How do I use an excel 2010 formula to change to color of a c

Report •

#1
March 28, 2012 at 08:20:30
✔ Best Answer
Your looking for Conditional Formatting.

See if this works for you:

This is for Excel 2007
There are Three separate formulas,
and they must be in the correct order.

First Formula:

1) Select your cell or Range of Cells, IE: cell B1
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.

5) Enter the formula: =A1=1

6) Click on the Format button
7) Select the Fill Tab
8) Select a Blue color
9) Click OK
10) Click OK

Second formula:

1) Select your cell or Range of Cells, should be the same as above.
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.

5) Enter the formula: =A1=2

6) Click on the Format button
7) Select the Fill Tab
8) Select a Orange color
9) Click OK
10) Click OK

Third Formula:

1) Select your cell or Range of Cells, should be the same as above
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.

5) Enter the formula: =a1=3

6) Click on the Format button
7) Select the Fill Tab
8) Select a Red color
9) Click OK
10) Click OK

Now when you enter a number, from 1 to 3, in cell A1, cell B1 will change color.

MIKE

http://www.skeptic.com/


Report •

#2
March 28, 2012 at 10:46:32
Wow! Thank you ever so much. It works perfectly

Report •
Related Solutions


Ask Question