+ Reply to Thread
Results 1 to 3 of 3

Conditional Format with Icons - rules won't "stick"

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Portland, Or
    MS-Off Ver
    Excel 2007
    Posts
    1

    Conditional Format with Icons - rules won't "stick"

    I must be doing something wrong because I keep going into Conditional Formatting - Icon Set - More Rules and "Reverse icon order" so Red is first, I set the values I want (red when value is >= 91 Percent, Yellow when <91 and >= 70 and this then sets Green to when <70. I get the first cell to work but all the other cells show Red no matter what the % in the cell. I figure this is a very basic question but for the life of me I can't get it to work. I am attaching my test speadsheet with just three rows with % that would meet each of the colors. (not sure my attachment worked though)

    Also, how can you tell what conditional formatting is set. When I go back to conditional formatting it is reset to the default and doesn't tell me how my cell is currently set. Thank you so much! (This is my first post)
    Attached Files Attached Files
    Last edited by portlandjackie; 11-21-2012 at 03:19 PM. Reason: set to solved

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,173

    Re: Conditional Format with Icons - rules won't "stick"

    Type should be formula.
    Attached Files Attached Files

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Conditional Format with Icons - rules won't "stick"

    Hi portlandjackie,

    Also, in C2 you don't need the SUM funtion >> =A2/B2
    HTH
    Regards, Jeff

+ 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