+ Reply to Thread
Results 1 to 2 of 2

Can text within concatenated formulas have a different color?

  1. #1
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    198

    Can text within concatenated formulas have a different color?

    I am using Excel 365 and have the following formula:

    ="Hours (per "&IF(D1=1,"Table 1","Table 2")&")"

    I would like it to show as Hours (per Table 2)

    Thanks for your help,
    RR

  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,507

    Re: Can text within concatenated formulas have a different color?

    No, you can't do that.
    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. [SOLVED] Partially change font and color of a concatenated string - possible? Please help
    By sumans054 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2019, 09:43 PM
  2. Change color of certain text from formulas value
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2017, 04:55 AM
  3. Need a function to concatenated cell preserving the color in the source text
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 09:54 PM
  4. [SOLVED] Use concatenated text as name in formulas
    By Apollo63 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2006, 11:10 AM
  5. converting concatenated text strings into formulas
    By z.entropic in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2006, 01:20 PM
  6. Conditional formulas: color code text populated cells?
    By TKT in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2005, 10:05 PM
  7. How to use formulas in Excel to control the text color ?
    By Jackie Cao in forum Excel General
    Replies: 2
    Last Post: 01-24-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1