+ Reply to Thread
Results 1 to 4 of 4

CF icon set based on text not values

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    CF icon set based on text not values

    I want to put in place a CF icon set of either a green tick or a red cross in cells A1:A20 but when I get to "Manage Rules option box" It is only showing me that I can use "values". Is there a formula that i can use to make it choose the icon set based on text of either "y" or "n" in cells A1:A20 .
    I have tried to just change the font to "wingdings2" but other need to use the worksheet and they wont know to use the corresponding text of "O" & "P"
    I've thought about writing a code but I have know idea on how to do that either.
    Any help greatfully appreciated.

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: CF icon set based on text not values

    Not quite what you wanted but you can get the green tick and the red cross in the next column.

    Have a look at the attached:

    CON FORMAT - WINGDINGS.xlsx

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: CF icon set based on text not values

    Or maybe this?
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: CF icon set based on text not values

    If you can use 1 and -1 instead of Yes and No then you can do it.
    Use custom number format to actual display Yes and No.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    10-11-2013
    Location
    Victoria, Australia
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: CF icon set based on text not values

    dank u waarderen helpen, ik begreep Hope this is right

+ 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. Show cell value(text) in comment box text, or mouse tool tip on an gif icon
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-19-2014, 06:50 AM
  2. Sum values in range of text strings based on other values
    By afgoody in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2013, 04:15 PM
  3. Replies: 2
    Last Post: 06-13-2012, 11:20 AM
  4. use vbasic to create icon conditional formating based on other cell values?
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2012, 02:56 PM
  5. Icon sets based on text - conditionanl formatting
    By aaboss in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2011, 12:51 PM

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