Results 1 to 7 of 7

Conditional formatting with icon sets

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    30

    Conditional formatting with icon sets

    Hi,

    I have attached a Yearly Goals template that I have put in place to rate the players that I coach with regards to their progress made/targtes hit.

    I wanted to use the icon sets available in excel to give the worksheet a professional look. I could not work out how to use the icon set where text was inserted so I used the following formula -

    =IF(H11="R",3,IF(H11="A",2,IF(H11="G",1,"")))

    and had the relevant icon appear in "H12", I then formatted the "H11" cell white font so it look liked when R,A or G was inserted the said icon would appear.

    The problem I keep running into is that because I have made the text column narrow and white font (as I really wanted it so it looks like just an icon appears) coaches that are filling the template in will automatically delete the icon if they have made an errror when inputting their rating!! This then deletes the formula, which in turn means the conditional formatting is not applied.

    To cut my above ramblings short lol!! I was hoping that there was anyway I could use text for icon sets to eliminate the need for using a formula!!

    Thank you

    Col
    Attached Files Attached Files

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