Hi
Trying to do a weakest link type game for kids.
There are 9 questions and a progress bar (thermometer type)
if question answer is correct £100 is added and the bar moves up a step. If
the answer is incorrect they lose £100 and the bar goes down 100.
I tried to set this up various ways using IF forrmula, then Macros attached
to a graphic button , and feeding into a conditional format cell shading to
increase the thermometer bar in steps. I got the conditional format to work
with a simple cell entry but can't figure how to progress it to do what I need
None work. I think it may need vB code which I know very little about. (or
a simple way to do it I don't know about!)
Could a kind person help me out?
Thanks
This is driving me nuts!