Results 1 to 2 of 2

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
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    87
    Articles
    0
    Excel Version
    O365
    Hi & welcome to the board.
    A formula cannot change the format of a cell.

Posting Permissions

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