Results 1 to 2 of 2

Formula to change font color in concatenate cell

Threaded View

  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

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