+ Reply to Thread
Results 1 to 2 of 2

Write in two colors in a cell

  1. #1
    Registered User
    Join Date
    03-14-2017
    Location
    France
    MS-Off Ver
    2010
    Posts
    18

    Write in two colors in a cell

    Hi Everyone,

    I am comparing two tables from different sources which in theory should be the same. I'd like to be able to see the difference and if difference what is in each table to solve the difference.

    I have the done the below formula which works well:
    =IF('PG22-26'!E12='ELT File PG22-26'!E12,"",'PG22-26'!E12&"&"&'ELT File PG22-26'!E12)

    However, everything is in black and difficult to read. Does anyone know if I could write what is in the first table in red (cf. in red above) and what is in the second table in green (cf. in green above).

    Thanks,
    Maxime

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Write in two colors in a cell

    No, it is not possible. It is not possible to have different colors in the result of a formula.

    The only way it could be done is to use a macro to: calculate the formula, put the resulting value in the cell, and color the result as desired.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] VBA code to change Excel chart bar colors as per cell colors
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2016, 03:29 AM
  2. Changing cells and column chart colors based on cell colors
    By HDeuce in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2016, 11:43 AM
  3. Replies: 3
    Last Post: 10-21-2015, 03:51 PM
  4. Replies: 16
    Last Post: 12-12-2014, 06:19 AM
  5. Replies: 1
    Last Post: 08-01-2014, 10:33 AM
  6. Replies: 3
    Last Post: 08-08-2008, 06:12 AM
  7. Can't format font colors or cell fill-in colors
    By canoeron in forum Excel General
    Replies: 3
    Last Post: 08-22-2005, 07:05 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