+ Reply to Thread
Results 1 to 4 of 4

Formula to turn text different colours

  1. #1
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103

    Formula to turn text different colours

    Hi,

    CAn somebody advise of a formula I can use to turn certain text in cells, certain colours.

    What I'm aiming to do is when my figures show a loss, I'd like the cell text to show in red (automatically) and when they're showing a profit, I'd lke the colour to be green.

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    523
    You can do this using a combination of normal formatting and conditional formatting:

    Select the cells showing your profits or losses
    Click the 'Format' menu and choose 'Conditional formatting...'
    {From the dialog box which appears} Choose 'Cell value is' | 'Less than '| 0
    Click the 'Format...' button
    Click the 'Font' tab and set the colour to red. Press OK twice to exit the dialog.
    Select all your profits and losses and click the font colour toolbar icon- it's a letter A with a colour underneath. You can set the default colour to green.

    This will show positive values in green and negative values in red.

  3. #3
    Forum Contributor
    Join Date
    04-10-2006
    Location
    Somerset
    MS-Off Ver
    MS Office 2007
    Posts
    103
    Brilliant - thanks !

  4. #4
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    523
    You're welcome and thanks for the feedback!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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