PDA

View Full Version : EXCEL



20-05-1999, 06:12 PM
EXCEL 5 CHALLENGES:
1) TIME DELAY. I WANT TO MAKE A MATHS GAME IN WHICH THE ANSWER OF A SIMPLE SUM IS DELAYED X SECONDS TO ALLOW THE STUDENT TIME TO THINK UP HIS/HER ANSWER AND ENTER IT INTO A SQUARE BEFORE THE CORRECT ANSWER POPS UP BELOW (F4). IS THERE A FORMULA?
2) DIRECTING A CELL TO CLEAR ITSELF. IF I PUT 'Y' IN CELL B1, CAN CELL B2 BE MADE TO <CLEAR>?
3)CHANGING BACKGROUND COLOUR. CAN THE ANSWER CELL FROM 1 ABOVE BE MADE TO BE A BACKGROUND (OR SPECIFIC) COLOUR, AND THEN TURN WHITE WHEN THE ANSWER POPS UP?

PLEASE DON'T TELL ME I NEED TO LEARN PROGRAMMING!

REGARDS
GRAHAM BOCKETT
<gbockett@iconz.co.nz>