Posts: 3,618
Threads: 326
Joined: Aug 2012
Staff roles: Server Administrator
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?
(03-29-2015, 05:17 PM)Snoopy Wrote: 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)
Posts: 3,618
Threads: 326
Joined: Aug 2012
Staff roles: Server Administrator
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.