Solved change font color of cell depedant upon it's value

March 15, 2014 at 16:59:14
Specs: Windows 7
I have a cell that with a SUM function that returns a percent value. I want it to display blue when it returns 100% and red if less than or greater that 100%. I've tried using conditional formatting but I can only seem to get it to change one color and it won't change the color when the SUM'd cells change.

See More: change font color of cell depedant upon its value

Report •

#1
March 15, 2014 at 17:23:18
✔ Best Answer
You will need two formulas to get what your looking for:

With your =SUM() in cell A1

First Formula:

1) Select your cell or Range of Cells: A1
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=100

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<>100

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

Conditional Formatting requires only that a formula returns TRUE.

See how that works for you.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question