Thursday, March 6, 2014

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 NUMBERICCNEWEGGPROVANTAGE
9260-4i367.20294.99301.78
9271-4i386.64383.99381.29
9260-8i468.72479.00477.38
9271-8i528.12511.90530.92
LSIIBBU07 (9260)158.22156.99171.43
LSICVM01 (9271)208.44176.99188.13

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