Wonder if any Excel ppl can help me with 2 things;
First off, I have a spreadsheet with 6,000 users, there in a list that start in A1 and go right the way down to A3000.
In B1, B2.. etc id like to change into a tick box. is this possible?
as in, i get to be able to tick it if i needed, not as like a tick
secoundly, i have a spreadsheet that gets updated daily.
if a team is performing well, there % stats gets changed to green, (below %10 - green)
between 10% and 15% they get colourd yellow, and anything over gets colourd red.
at the moment i do this manuly, is there a fourmula i can use so that the % get colourd in the right colours?