I want to compare the values(negative & postive both) and produce result accordingly

[costinkris]

Hi everyone,

my problem is that i want to compare the values in 2 different column and if the difference is greater than 100 then the result should be highlighted as green and if the difference is less than -100 than the cell should be highlighted as red.

for ex if the comparing values are 2245, 2645 then 2645-2245=400 which is greater than 100 so the column should be highlighted as green

but if we reverse the values and take difference i.e. 2245-2645= -400 which is less than -100 so the resulted column should be red.

Please help.

[Ace_XL]

Use two conditions in conditional formatting,

1. if result is greater than 100, green
2. if result is less than -100, red

[Russell Dawson]

See attached example. Using formula to determine which cells to format.

[costinkris]

Thanks Russel & Ace_XL but actually what i am trying to do is compare the value of a single metric from 2 different tables (i am using vlookup to get the same metric compared) and depending upon the difference i want to show my result only in the form of red/green arrow (not the values itself).
Is it possible to compare the values and show results in a single column?