+ Reply to Thread
Results 1 to 2 of 2

Formula to change font color in concatenate cell

  1. #1
    Registered User
    Join Date
    12-10-2021
    Location
    Montreal, Canada
    MS-Off Ver
    2013
    Posts
    1

    Formula to change font color in concatenate cell

    Hi all,

    Here is my question.

    I would like to concatenate 3 values in one cell. The result I am looking for is the last row of the document I attached. Each value can have a different color based on the color code legend.

    For those who cannot open the file, the font in the cell should look like that : 5 / 30 / 44

    thanks a lot for your help!
    Shawn
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Formula to change font color in concatenate cell

    If the content of cell B6 is intended to be the result of a concatenation formula, you will not be able to colour individual numbers in the way you have outlined. Obviously, you can colour individual characters if the content of the cell is text.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. VBA Font and color change in cell if formula is in use
    By Blaz_SLO in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2021, 02:14 PM
  2. Font and color change in cell if formula is in use
    By Blaz_SLO in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2021, 05:48 AM
  3. Concatenate two cells, change font color and put in the third column
    By susan.stein in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2021, 04:29 PM
  4. Want to partial change of font color for CONCATENATE formula
    By Swapan.Baishnab in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2016, 07:03 AM
  5. Change font color based on font color of another cell
    By Ibyers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 09:36 AM
  6. I need a formula or macro to change font color for each cell in range
    By gioithe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2009, 04:30 PM
  7. Change font/cell color by Formula
    By exutable in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2006, 10:15 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