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
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
-------------------------------------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem
No comments:
Post a Comment