Macro to highlight cells which have content with an end punctuation

**Athi123** · 01-30-2013, 06:22 AM

Hi,

I need to highlight the cells which have sentence with an end punctuation (comma, semicolon, colon, hyphen, period or fullstop).

I need a macro for this.

Please help.

Thanks.

**OllieB** · 01-30-2013, 09:18 AM

Assuming sentences are in column A

Please Login or Register  to view this content.

**Athi123** · 01-31-2013, 01:30 AM

Hi,

Thanks for the macro. Could you please update the macro so that sentences in many columns may also get highlighted.

This macro works fine while pasting the data in only one column (Column A), but what has to be done if we have multi-columns.

Thanks.

**OllieB** · 01-31-2013, 02:33 AM

How would you like the macro to be updated, i.e. how are you going to tell the macro which columns to check? Do you want to select some columns and should the macro then check the selected columns?

**Athi123** · 01-31-2013, 02:52 AM

Hi,

I'm having data in 20 columns. I want the macro to check all the columns irrespective of selection.

Thanks for the response.

**OllieB** · 01-31-2013, 02:56 AM

Try

Please Login or Register  to view this content.

**Athi123** · 01-31-2013, 03:04 AM

Hi,

Thanks. It's working.

Thanks a lot.

Macro to highlight cells which have content with an end punctuation

LinkBack

Thread Tools

Rate This Thread

Display

Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Re: Macro to highlight cells which have content with an end punctuation

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions