+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting for every Nth word

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    Turkey
    MS-Off Ver
    Pro plus
    Posts
    1

    Conditional Formatting for every Nth word

    Hi everyone,

    I need a function or macro (not even sure which one I need) that can:

    1) highlight every Nth word in the text in a cell
    2) list every Nth word under a column

    is this possible in excel or should I look for other solutions?

    Thanks in advance.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,650

    Re: Conditional Formatting for every Nth word

    Conditional formatting can't apply character-level formatting. It would require VBA.
    Entia non sunt multiplicanda sine necessitate

+ 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] Conditional Formatting Word and Numbers
    By mellon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2018, 01:56 PM
  2. [SOLVED] Conditional formatting in excel/word
    By k11ngy in forum Word Formatting & General
    Replies: 3
    Last Post: 01-25-2017, 06:39 AM
  3. Conditional formatting for new excel on word
    By ZiDanno in forum Excel General
    Replies: 10
    Last Post: 03-10-2016, 03:54 PM
  4. Replies: 2
    Last Post: 10-30-2014, 01:49 AM
  5. [SOLVED] Need help with conditional formatting if other cell contains a word
    By JackBauer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-29-2012, 01:41 PM
  6. Conditional Formatting - Numbers & Word
    By mbe23 in forum Excel General
    Replies: 2
    Last Post: 03-16-2011, 01:31 AM
  7. Conditional formatting using a trigger word
    By stevewilde in forum Excel General
    Replies: 1
    Last Post: 10-15-2009, 09:29 AM

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