Thank you worked perfectly, I wish I had joined the forum earlier. Thank you for such a rapid response also.There are lots of other questions around this theme, like can I change the colour of the cell say Red for Fail and Green for pass. Should I post this question in a new thread? I am new to forums as well as Excel.