Google Docs - Picking out the highest value cell

[Connor]

So I'm having a slight problem finding a way of highlighting the highest value on a document that is always changing. Does anyone know how to select a group of cells and force all of the highest values in those cells to light up as a colour via conditional formating?

---

[SnakThree]

So I'm having a slight problem finding a way of highlighting the highest value on a document that is always changing. Does anyone know how to select a group of cells and force all of the highest values in those cells to light up as a colour via conditional formating?

Not sure about highlighting it, but you can make new cell with =MAX(range)

---

[Connor]

I think I've nailed it now with your help, @Snak3. I did your =MAX() and then entered a =VLOOKUP() and it seems to have worked so far! Cheers for the help.

Edit: What I've done hasn't worked... QQ

Edit2: This is what I have so far



The problem is that It works for this because the Vlookup is searching for the 3rd row, but when the votes go to, lets say 4, it picks out the 4th name and places is where the highest vote is.

IE:

Names .................Votes

a..............................1
b..............................2
c..............................3
d.............................. 0
e ..............................1
f ..............................0
g ..............................0
h .............................. 1

Highest vote: C

Names .................Votes

a..............................4
b..............................2
c..............................3
d.............................. 0
e ..............................1
f ..............................0
g ..............................0
h ..............................

Highest vote: D

Because the highest value is 4 (A) so the VLOOKUP looks for row 4 and takes the letter D as the highest value where it should be picking out A because it has the highest amount of votes.

I hope that isn't too confusing.

---

[Connor]

Got it working by replacing the numbers on the left with the =COUNTIF() formulas used under the vote count and by keeping the =MAX()

---