Quick way to temporarily hide rows or cell content?

[NCJECulver]

Apologies for the lack of clarity in my question; I'm just starting to think about this. I'm really just looking for pointers in the right direction, not an answer.

I have a spreadsheet for tracking student grades that looks like this:

Occasionally I invite students to look at their grades, and I'm trying to figure out a way I can hide other students' information temporarily. I'm thinking the best approach would be with conditional formatting applied to Column A, perhaps something along these lines:

If $A$1 is <> "" and $A$1 <> $C$x then <set $A$x to white-on-white>

("x" above represents each row from 3 to 27).

Most of the time, then, I want to see all students, so I leave A1 blank. But when I want to hide all but one student's grade, I type that student's number (from Column C) into A1 and all other students go blank.

The problem is, this requires a double test, and I don't know how to set up conditional formatting for that. Or maybe I'm barking up the wrong tree.

Apologies in advance for the lack of clarity in my question.

CJ

[Dave]

Perhaps show on another page?

Example:

Sheet 1, rows 1-6:
Fred 1 7 13
John 2 8 14
Mary 3 9 15
David 4 10 16
Joan 5 11 17
Margot 6 12 18

Sheet 2:
Type a name in A2
In B2 have =VLOOKUP($A$2;$Sheet1.$A$1:$D$6;2)
In B3, =VLOOKUP($A$2;$Sheet1.$A$1:$D$6;3)
In B4, =VLOOKUP($A$2;$Sheet1.$A$1:$D$6;4)

This will show the row only for the student in A2.

David.