Colour

Hello,
Hi and thanks for previous help.
Last one for a while (I hope)

I am using the below formulae you gave me and it is fine. However these results run into the hundreds and
are from automarked EMI sheets. The autoreader sometimes cannot read the sheet as the student may have not rubbed a correction out properly, put more than one answer or left it blank.

When this happens the autoreader produces either blanks or greater than (>) signs on the original sheet that the below formulae works from. I would like these incorrect inputs highlighted in a pale colour on sheet1L so I can find then easily and check why the machine couild not read the student answer and make a judgement on the origianl student form. I find it very dificuilt, currently, to spot these anomalies amongst the normal inputs.

Maybe we leave this formulae alone and sheet 1L requires it's own cell formula.

=IF(ISBLANK(Sheet1L!E$4), "", IF(Sheet1L!E6=Sheet1L!E$4,1,0))

please advise
Richard