+ Reply to Thread
Results 1 to 3 of 3

Single macro for spell check, highlighting duplicate word and highlighting end punctuation

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Single macro for spell check, highlighting duplicate word and highlighting end punctuation

    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.
    Attached Files Attached Files
    Last edited by Athi123; 02-06-2013 at 12:12 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Single macro for spell check, highlighting duplicate word and highlighting end punctua

    Suggest you up load a sample spreadsheet to work with.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Single macro for spell check, highlighting duplicate word and highlighting end punctua

    Hi,

    Thanks for the reply.

    Please see the attachment (sample sheet).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • 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