I have date in excel sheet like below

A B

1 7 6

2 5 6

3 5 5I 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 BlackThank you

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 OKMIKE

Ask Your Question

Weekly Poll