+ Reply to Thread
Results 1 to 3 of 3

Counting words in RED

  1. #1
    Registered User
    Join Date
    08-02-2017
    Location
    Phoenix
    MS-Off Ver
    2013
    Posts
    4

    Counting words in RED

    Hello,

    Is there an option to count the words in RED in a string.

    Example:

    Cell A1: Autumn season is around the corner

    Cell A2: 2

  2. #2
    Registered User
    Join Date
    07-14-2017
    Location
    Hà Nội
    MS-Off Ver
    2013
    Posts
    12

    Re: Counting words in RED

    I think there isn't option like that ^^

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Counting words in RED

    This has to be done with a macro, and is non-trivial.

    What happens if only part of a word is red?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] counting occurrence of specific words in another group of words
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2021, 07:33 PM
  2. Counting occurrences not values.. Counting blocks of words in columns
    By Flydd in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-01-2016, 06:42 PM
  3. Counting words
    By NoBob in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-18-2016, 01:51 AM
  4. [SOLVED] Counting Words
    By corn1991 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2015, 09:09 AM
  5. counting words
    By Duckie in forum Excel General
    Replies: 2
    Last Post: 01-18-2010, 07:28 PM
  6. Counting Words
    By tkinsella in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2006, 07:23 PM
  7. Counting words............
    By Smokey_Vol in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-21-2005, 11:35 AM

Tags for this Thread

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