Conditional Formatting

Hi,

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 :)

Regards

Hi Steven,

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

=$A1=MAX($A$1:$A$3)
then of course add the correct colour.

Probably easier of I just sent you the sheet? :)

PM'd you mate