How to Change Font color depend on value

March 4, 2012 at 08:04:58
Specs: Windows 7
I have date in excel sheet like below
A B
1 7 6
2 5 6
3 5 5

I want the font color column B become Red when its cell value bigger then the value in column A.
The different color for vice versa.
B1 Yellow, B2 Red B3 Black

Thank you


See More: How to Change Font color depend on value

Report •


#1
March 4, 2012 at 11:32:20
Not sure I understand what your doing,
but Conditional Formatting is what your looking for.

Conditional Formatting 2003

1) – Select the cell or range of cells

On the Menu Bar:

2) - Format
3) - Conditional Formatting
4) – Change “Cell Value is” to “Formula Is”
5) – Enter the formula:

=B1>A1

Sub Menu Format :
6) - Patterns
7) - Choose Red
8) - Press OK
===========================================================

Conditional Formatting 2007

1) Select your cell or range of cells
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:

=B1>A1

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

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question