Thread: how to change the color of a cell if the value of it is greater than another cell

i have two column..for ex.
original_value modified_val..
2 2
2 3 so if modified_val is greater than original_val the cell should become red color...and this rule should be applied to all rows coming under this column...
using condition formatting i have to do separately for each cell..it's difficult as more than 500 columns are to be entered..

hi

Here is what I'm using:
Say ur Mofidied_value is Colum G and original_Value is Colum F

=IF($F2="";"";AND($F2<$G2))

This you would have to enter under Data/Conditional Formatting/New Condition

And then you select the last part where it says Use a Formula to make a condition

And you have to set the condiriton that the condition is for say $G$2:$G$200

What this formula does it check if Original_value has a value - if it doesn't it doesn't color the Modified_Value
But if Original_Value isn't empty then it checks if Modified_Value is grater then Original_Value if the Modified_Value is biger it colors it red.
You have to set the color to red in the Conditional formatting options.

Originally Posted by stojko89

hi

Here is what I'm using:
Say ur Mofidied_value is Colum G and original_Value is Colum F

=IF($F2="";"";AND($F2<$G2))

This you would have to enter under Data/Conditional Formatting/New Condition

And then you select the last part where it says Use a Formula to make a condition

And you have to set the condiriton that the condition is for say $G$2:$G$200

i am using excel 2007...original_val is starting from F9 and modified_cal is from K9...i applied your code in New Formating Rule->Format values where this formula is true..but it says the code is wrong and where i have to use this code G$2:$G$200(k2:k200)

But it works?

Originally Posted by stojko89

But it works?

no it shows error..can you elaborate it once more

Ok so I guess not.
I've left out this part of code:

IF($A2="";""...)

The code works now as you said. You can see it under Data/Conditional Formatting.

Check the workbook I've uploaded.

You just need to fix it so it your workbook so it works for the range you want it to.

Thanks a lot stojko89...i have successfully solved this issue by following your instructions..so many Thanks for you and the Excel Forum for giving such an environment ..and i am sorry for quoting all post as i am new in such type of forum...