+ Reply to Thread
Results 1 to 5 of 5

Format Increase/Decrease Sign so it is at the far right of the cell

  1. #1
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Format Increase/Decrease Sign so it is at the far right of the cell

    I have have a formula to show the increase or decrease forllowed by a symbol for the increase or decrease



    I would like to know how to set a custom format so that the symbol is formatted neatly or to the far right of the cell
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Format Increase/Decrease Sign so it is at the far right of the cell

    There are icon sets in conditional formatting that do this job if you like.

  3. #3
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Re: Format Increase/Decrease Sign so it is at the far right of the cell

    Thanks kersplash. I have not used these before so am usure on how to use these


    Please let me know how to incorporate these in my formula to show the increase or decrease per my attached sample data

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Format Increase/Decrease Sign so it is at the far right of the cell

    I don't know much about them either but quickly made was is attached.
    Attached Files Attached Files

  5. #5
    Spammer
    Join Date
    08-20-2012
    Location
    Canada
    MS-Off Ver
    2007
    Posts
    221

    Re: Format Increase/Decrease Sign so it is at the far right of the cell

    Thanks for the help

+ 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. Increase/Decrease Cell Value and Select from ListBox
    By vorabj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-20-2018, 09:36 AM
  2. Replies: 3
    Last Post: 06-16-2015, 12:32 PM
  3. Buttons to Increase & Decrease number in a cell
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2012, 11:53 AM
  4. Replies: 3
    Last Post: 09-18-2012, 01:01 AM
  5. how to increase/ decrease cell value incrementally?
    By naira in forum Excel General
    Replies: 2
    Last Post: 06-12-2012, 09:06 AM
  6. Replies: 7
    Last Post: 07-18-2006, 11:50 PM
  7. [SOLVED] How do I set a cell that can increase but never decrease?
    By Rich in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 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