"X" indicator while........I put X through the range...
Posted by NiuB on November 16, 2001 6:35 AM
Hello again guys...long time no see..I got a problem..
I don't know how to revealed it correctly..
i have data in range a4:k4
1. item is in a4:a8
2. name in b4:b8
3.questions number in range c4:i8( in these cell i need to put "X" when my student get wrong)
4.total of "X" in range j4:j8 ( i use the formula countif to count the "X" )
5. the student marks in range k4:k8 (the "X" total multiply 2 to get the student marksl )
I need to put "X" when my student got a wrong answer in my report..so I will put X..my
problem is..I need to know their marks while I put X..because sometimes I
accidentally put "X" unintentionally..so..can you guys figure a way..like when I in..let
say...cell c4:i4..some thing like message of comment will appear and show me the
student marks ( K4 ) while I put "X" on them..is it possible..i know I can use freeze
panes.but it take a lot of work to scroll left and right..you know what I
mean..sometimes its involving 100 questions and you can imagine how difficult it
is for mr to see the marks..some people suggest split screen..but thats not i'm looking
for..i'm intend some indicator or something to appear while I put the "X"..its more fun and I
think a new technique..I guess..lol....thanks a zillion...