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
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
No comments:
Post a Comment