yogi_Apply Conditional Formatting to Highlight Lowest Price of Part Row By Row

                                         Google Spreadsheet   Post  #1553
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-06-2014
post by rickprendergast  (https://productforums.google.com/forum/#!mydiscussions/docs/d8eU-paF08k)
Conditional Formatting - Comparing one value to multiple values

Hi,

I am using the new Google Sheets and I am trying to compare multiple values and change the background of the lowest value to green.

Here is a sample of what I am doing.  I would like to make the cell with the lowest price for each part turn green.

Thanks for your help.

Rick

PART NUMBER	ICC	NEWEGG	PROVANTAGE
9260-4i	367.20	294.99	301.78
9271-4i	386.64	383.99	381.29
9260-8i	468.72	479.00	477.38
9271-8i	528.12	511.90	530.92
LSIIBBU07 (9260)	158.22	156.99	171.43
LSICVM01 (9271)	208.44	176.99	188.13

Here's a link to the Google Sheet

https://docs.google.com/spreadsheets/d/1ZdKjzD1dEysH7YA4_fZESWaGGqSlX6nlvuRI3BnT3XA/edit?usp=sharing

Rick

-------------------------------------------------------------------------------------------------------------------