+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting - Quarters Icon Sets set via list values

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Jacksonville, fl
    MS-Off Ver
    Excel 2007
    Posts
    4

    Conditional formatting - Quarters Icon Sets set via list values

    I have a status column (A) which list values are set in column (AA). The values are Not Started, Started, Elements Defined, Validation Completed, Completed. As the user chooses the correct status from the drop down list in col A, I want the conditional formatting rule to change that into a Quarters Icon set icon sunch as a full circle for Completed, half circle for Elements Defined etc... Only way I can think of this working is using a formula, but not sure how to. Thanks in advance for your help.

  2. #2
    Registered User
    Join Date
    01-16-2012
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Conditional formatting - Quarters Icon Sets set via list values

    Dirty Confession: Conditional formatting always confuses me.

    Now that we have that out of the way, you can change the criteria and for the Quarters. To do this, add the formatting to the range then go to 'Manage Rules...'. Select the formatting you just added and 'Edit Rule'. Here you can change the quarters to equal the values available in column A. Just set column AA equal to column A (and select 'show quarters only' if you desire) and I think you are good to go.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,114

    Re: Conditional formatting - Quarters Icon Sets set via list values

    Hi and welcome to the forum

    Hi and welcome to the forum

    This doesnt answer your question as such, but may help with future CF situations.

    What I sometimes do, if I an working with a tricky CF formula, is I create it IN the worksheet itself to begin with. That way, you can play around with it easier to get it to do what you want. All you have to do is construct the formula in such a way that if gives a TRUE or FALSE answer - those are the only answers CF works with. So for instance, if you want to highlight numbers >50, then the formula would be just that...
    =A1>50
    =A1="name"
    =A1<>"word"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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