Excel Help..

[FlasHBurN]

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]

Conditional formatting is your friend

you'll need to use an if statement

pm me if you need specifics

 

[NeoV]

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

 

[FlasHBurN]

Awesome! Thanks much.