+ Reply to Thread
Results 1 to 4 of 4

Coloring cell letters based on text cases

  1. 01-31-2017, 10:44 AM #1
    gan_xl
    gan_xl is offline
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Coloring cell letters based on text cases

    Hi,

    Please see the attached file.

    I have a set of characters in a cell, would like to color red for capital letters and blue for the rest.

    I need a macro to do this and NOT a formula or conditional formatting.

    Please help me.
    Attached Files Attached Files
    Last edited by gan_xl; 01-31-2017 at 10:46 AM.
    Reply With QuoteRegister To Reply
  2. 01-31-2017, 11:42 AM #2
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Coloring cell letters based on text cases

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-01-2017, 06:20 AM #3
    gan_xl
    gan_xl is offline
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Coloring cell letters based on text cases

    Thank you so much John. It works great .
    Reply With QuoteRegister To Reply
  4. 02-01-2017, 08:14 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Coloring cell letters based on text cases

    You're welcome. Glad to help out and thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Waterfall Chart with automatic coloring and text coloring
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2013, 05:54 PM
  2. [SOLVED] Conditional Formating, Coloring Each Row Based On Cell Value, 500+
    By bmsrmd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2012, 02:50 PM
  3. [SOLVED] Coloring cells based on value in another cell
    By killerthun in forum Excel General
    Replies: 2
    Last Post: 08-16-2012, 08:21 AM
  4. [SOLVED] Coloring Cell based on unique entry
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-16-2012, 03:04 PM
  5. Coloring cell based on condition
    By rajaid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2009, 08:08 AM
  6. cell coloring based on duplicates
    By novice2430 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2008, 08:19 AM
  7. Coloring row based on cell value
    By novice2430 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2008, 06:00 PM
  8. Coloring Based on Text Criteria in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-19-2007, 12:31 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1