Hi,

I need a macro which has to do a complicated task:

(i) It should do spell check for the entire sheet and highlight the mis-spelled words (bold red color)
(ii) There are text in Columns B and C. Column B having text or even a word same as Column C should be highlighted (yellow highlight). For ex: LG Blue Washing Machine in Column B and LG in Column C.
(iii) Columns E-V (Say 18-20 Columns) are having text. The macro should check for any end punctuation (it should check only at the end of the sentence) in the text (comma, semi-colon, colon, hyphen, end-dot or full stop). The text having end punctuation should be highlighted (red highlight).

Please help me.

Thanks in advance.