Excel Help..

FlasHBurN

Golden Member
Oct 12, 1999
1,349
0
76
I am trying to make a formula that changes the color of a cell, depending on how it compares to another...

For example I have a cell (A2), I want to compare its value to another cell (B2). If B2 is greater than A2, I want to change the color of A2's cell.

I already know how to change the color of a cell based on its comparison to a specific number, but I cannot figure out how to change it based on the value of another cell.
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
Conditional formatting is your friend

you'll need to use an if statement

pm me if you need specifics
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
ok, specifics...

in cell A2, go to format-conditional formatting

first box should say "cell value is", 2nd box should say "is greater than", third box should say "=$b$2

click on the format box, choose the 'patterns' tab, and select your color - you should be all set

you may also want to put in some data validation conditions to make sure the values in column A are only numbers too