Hi, first time on the forum.

I have an excel 2003 spreadsheet and would like to hide different ranges of rows based on the value of one cell.

If C3 = 12 then hide rows 26 to 104
If C3 = 11 then hide rows 5 to 24 and rows 49 to 104
IF C3 = 10 then hide rows 5 to 43 and rows 71 to 104
IF C3 = 9 then hide rows 5 to 65 and rows 90 to 104
IF C3 = 8 then hide rows 5 to 86

Worksheet is called "UNDER 15's Knock out"

Any help would be much appreciated.

Thanks