Single macro for spell check, highlighting duplicate word and highlighting end punctuation
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1