Sunday, January 1, 2017

yogi_Conditionally Format In Column B Top 3 Unique or Non-Unique Entries as noted

Google Spreadsheet   Post  #2101
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-01-2017
How do I custom format the 1st, 2nd, and 3rd highest number in a column?
I am running a small sweepstakes competition, using google sheets so everyone can access it. I want it to automatically update who is in 1st, 2nd and 3rd by changing the color of their cell. Placings are based on who has the highest amount of points. What is a way I can do this or the closest I can get to doing this?