+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - setting up a icon set rule for traffic light icons??

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    London
    MS-Off Ver
    Mac 2011
    Posts
    2

    Conditional Formatting - setting up a icon set rule for traffic light icons??

    Hi all,

    First post here so apologies if it is unclear at all.

    I want to add in a Conditional Formatting Icon Set New Rule so that I get a traffic light icon based on a set of values from the sum of 2 columns. When I try to set the rule up I get the error message that "one or more data values overlap".

    I have tried to put in the 'New Rule Format' having the 'Value' in (i.e. >=8) and the 'Type' as "Number" - but this doesn't work.

    How do I create the rule that allows me to have the below icons showing when the cell has the below number ranges:

    Green icon = 0-8
    Amber icon = 9-17
    Red icon = 17-25

    Thanks

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Conditional Formatting - setting up a icon set rule for traffic light icons??

    if the first range includes 8 the second has to be >8 and not >=8
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    03-26-2013
    Location
    London
    MS-Off Ver
    Mac 2011
    Posts
    2

    Re: Conditional Formatting - setting up a icon set rule for traffic light icons??

    Very simple.... it works. Thank you

+ 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