Comparing values in three columns with conditional formatting

[Jason Grunert]

Hello, I have a table where I have a list of items with three years worth of billing margin data, like so:

ITEM 2010 2011 2012
A-WIRE 19% 18% 12%
B-WIRE 12% 12% 11%
C-WIRE 17% 13% 18%

What I would like to do is set up a rule where the highest of the three values is in a green-shaded cell, the mid-value is yellow, and the lowest value is red. Though the values could be the same across all three years for some items, and some columns are missing data because there were no sales that year. Is there a conditional formatting rule I can set up to do this, or does the lack of data in some cells make this impossible?

If it can't be done, I'd settle for a rule where I could just highlight each cell red if it's lower than the previous year's value. I have tried to get this to work without any luck. Any help you could provide would be appreciated!!

[Fotis1991]

If you have to compare 3 columns, as your example,Try in Conditional formatting rules.

=B2=LARGE($B2:$D2,1)>>>for the biggest

=B2=LARGE($B2:$D2,2)>>>for the mid

=B2=LARGE($B2:$D2,3)>>.for the smallest

[mehmetcik]

here is your sample

set the table background to yellow and use two conditional formats to change them to red or green.

[Jason Grunert]

I couldn't get the first example to work (ended up with only one cell in the whole field highlighted), but thank you Fotis1991 for taking the time to respond. I'm sure I was just missing something in how I was doing it.

However, mehmetcik, I got your example to work perfectly! Thank you very much! That is exactly what I wanted!