+ Reply to Thread
Results 1 to 7 of 7

formatting percentage values

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    formatting percentage values

    Hello,
    if the non-empty cells have a value, they become colored.
    But if they are empty how to do not to color them?
    max
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: formatting percentage values

    CF format cell that blank, with no format and put it on top.
    Attached Files Attached Files

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: formatting percentage values

    In the attached workbook there are the formulas to color the percentages.
    I added two more formulas to color the lines alternately.
    =ISEVEN($AA3)
    =NOT(ISEVEN($AA3))
    if there is no number in X, the cell must be colored like the line
    if cell S is empty it must see the word NOT with the color of the row
    I can not insert the exact way.
    max
    Attached Files Attached Files

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: formatting percentage values

    Is this right?

    isblank($X3) is not work change to =$X3=""
    Attached Files Attached Files

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: formatting percentage values

    Hi Bo_Ry
    it is not exact see the attached picture
    the alternating rows are missing
    the lines are alternating color if there is a number in column A
    Attached Images Attached Images

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,213

    Re: formatting percentage values

    This should work.
    Attached Images Attached Images
    Attached Files Attached Files

  7. #7
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: formatting percentage values

    Now Bo_Ry works
    Greetings and many thanks.
    max

+ 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. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  2. Percentage Values displays as Decimal Values - Excel 2010
    By Adecypher in forum Excel General
    Replies: 3
    Last Post: 05-28-2015, 06:07 PM
  3. [SOLVED] conditional formatting for percentage values
    By ivansamsonov in forum Excel General
    Replies: 6
    Last Post: 01-28-2014, 12:07 PM
  4. Pivot Chart displaying percentage values as decimal values
    By figo12 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2013, 05:02 PM
  5. Replies: 2
    Last Post: 04-04-2013, 12:44 AM
  6. Replies: 4
    Last Post: 01-03-2012, 06:05 PM
  7. Replies: 4
    Last Post: 05-28-2009, 04:08 AM

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