Results 1 to 3 of 3

Thread: formula to change font color of numbers, Please.

  1. #1
    Neophyte King.Nuthin's Avatar
    Join Date
    Oct 2019
    Posts
    1
    Articles
    0
    Excel Version
    2016

    formula to change font color of numbers, Please.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all,
    Is there a formula to change the font color of the numbers to the left of the decimal point or vice versa? I want the the numbers to the left of the decimal point to stand out. I would like to see them lime green or bright blue while the numbers to the right of the decimal remain black. Thank you all in advance.

  2. #2
    Conjurer Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    112
    Articles
    0
    Excel Version
    O365
    Hi & welcome to the board.
    A formula cannot change the format of a cell.

  3. #3
    Seeker mAdMaCCa's Avatar
    Join Date
    Jan 2020
    Posts
    5
    Articles
    0
    Excel Version
    Home & Business 2016
    Hi

    Pretty sure you cannot split formatting (such as color) within a cell.

    the only way I can think of your doing it is to split your before and after decimal number in to two cells, so 19 in one cell and the 99 in another for 19.99, then you can color one cell and not the other.

    Depending what you then need you can use conditional formatting to only change the color if it is over a certain value and so on.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •