Basicly im trying to create a league table, week 1, 2, 3 etc and then on cell h2 i have totals, just want a conditional formatting to highlight the whole row of the highest score in the totals, its been a while since ive messed around with excel so hoping someone can help :)
What version of office are you using?
2007 can do this easily via Conditional Formatting -> "Format only top or bottom ranked values"
Don't think this is in 2003 so we could get more creative if needs be.
Actually 2007 just highlights one cell.
What I have done to highlight the row is to use the inbuilt function to highlight the correct cell then used another rule for the other cells.
So for example I have three rows 1, 2, and 3, and three columns A, B and C.
Data goes in column A and has the inbuilt formula to highlight the highest cell.
I then use the following conditional formatting formula applied to the remaining cells to highlight the rest of the row
then of course add the correct colour.
Probably easier of I just sent you the sheet? :)