In using a conditional format I am able to change the cell formats
accordingly, but if I am only using basic formats to show the correct or
wrong answer to multiple choice questions then is there any way to count what
is right or wrong to the cells returning a percent correct mark? Maybe by
counting TRUE or FALSE? The answer in the cell is only ever going to be A, B,
C or D...

Regards,

Paul