[ms office - 2003] Conditional Formatting

[stevenwba]

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

[sparkeh]

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.

[sparkeh]

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?

[stevenwba]

PM'd you mate