change cell color auto.,

dreamdragon

New Member
Joined
Jul 9, 2005
Messages
11
Hi
I need to try and get a formula for changing a cells color if it meets certain criteria, EG:-

Cell A1 will change to green if cell B1 has a higher number than cell C1, and it will change to RED if B1 was lower than C1.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

In A1 goto Format-->Conditional Formatting-->Formula is-->=B1>C1-->Format-->Pattern-->Green.

Add a Condition and Formula Is-->=C1>B1-->Format-->Patterns-->Red.

Note that there will be no formatting if they're equal, but that may be what you wanted.

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,669
Members
412,481
Latest member
nhantam
Top