• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Mixing icon sets in conditional formatting and only using one icon from set 2

    Hui, I do not need to customize the icon sets, I like the built-in ones. All I want to do is have Excel leverage two different conditional formatting icon sets in one cell. So basically if the value is x,y,z use the red, green, yellow stop light. If the condition is a then use the red to...
  2. I

    Mixing icon sets in conditional formatting and only using one icon from set 2

    I really just want two instances of conditional formatting, your solution is VERY clever and quite good, but I want to stick with Excel's built in custom designed conditional formatting icons.
  3. I

    Mixing icon sets in conditional formatting and only using one icon from set 2

    So I don't have Excel 2010 yet, but I don't want Red, Yellow, Green, Black. I want Red, Yellow, Green, Grey. I also don't want to set the background colors, I want to use the grey circle from the Red to Black icon set. Any idea how to accomplish this exact task?
  4. I

    Mixing icon sets in conditional formatting and only using one icon from set 2

    So I created a way to show red, yellow, and green based on an if formula and conditional formatting. =IF((B3="Red"),1,IF((B3="yellow"),2,IF((B3="green"),3,"N/A"))) So if I put Red, the value is 1 and then I changed the cell color white so that all users would see is the icon and the icon...
Back
Top