Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    icon conditional formating - Excel 2010

    Greetings,
    I need help to apply icon style format beside cell value based on the following conditions:
    If cell value = 0 then no format
    If =100 then green icon
    If <100 then red icon
    If >100 then amber icon
    Any ideas how can this be done…
    TIA
    dubdub

  2. #2
    Lounger
    Join Date
    Jul 2014
    Posts
    33
    Thanks
    7
    Thanked 3 Times in 3 Posts
    I know a couple of ways to do this - Can you post a sample spreadsheet so I can see exactly what you're trying to achieve?

    I think the easiest way to manage this would be setting up conditional formatting rules, or maybe making a quick script for you which I'm more than happy to give a go!

    R

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    My appology, the previous file is not the one,please consider this one
    Attached Files Attached Files
    Last edited by dubdub; 2014-12-02 at 10:53.
    TIA
    dubdub

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,643
    Thanks
    115
    Thanked 652 Times in 594 Posts
    dubdub,

    Setup a 4 icon set like this:

    icons.png

    HTH,
    Maud
    Attached Files Attached Files
    Last edited by Maudibe; 2014-12-02 at 17:31.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Great Great Thanks Maudibe.
    TIA
    dubdub

Posting Permissions

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