Saturday, September 13, 2014

yogi_Apply Conditional Formatting To Cells Of Column D Start And End Row Numbers As Specified And Every Which Row Number As Noted

                      Google Spreadsheet   Post  #1760
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.
-------------------------------------------------------------------------------------------------------------------

following is the solution to a bit more generalized problem



No comments:

Post a Comment