Saturday, September 13, 2014

yogi_Apply Conditional Formatting To Cells D5 D7 D9 D11 D13 And D15 For Max Value In These Cells

                      Google Spreadsheet   Post  #1759
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-13-2014
post by markjj:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/MkvhbH0ooKY)
Custom formatting, making it look for the greatest value among several cells
I need custom formatting to look at cells, D5,D7,D9,D11,D13,D15 exclusively and change the formatting of the one that has the highest value or is equal to the one with the highest value.  This should be simple enough but I can't get it to work.  

I've tried GTE, MAX and RANK commands but none are working.
-----------------------------------------------------------------------------------------------------------------------------
Assuming markjj means Conditional Formatting I have presented a solution in the following