+ Reply to Thread
Results 1 to 7 of 7

How to flag list of cities based on continent?

  1. #1
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    How to flag list of cities based on continent?

    I have a two-column list of cities and continents:

    Prague; Europe
    Berlin; Europe
    New York; America
    Tokyo; Asia

    How can I show only the citites conditionally flagged based on the contintent value?

    Something like this:
    <red flag> Prague
    <red flag> Berlin
    <green flag> New York
    <yellow flag> Tokyo

    Any help would be appreciated!

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to flag list of cities based on continent?

    Perhaps a worksheet like this will be of help to you.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: How to flag list of cities based on continent?

    Thanks, newdoverman,
    but it's not exactly what I meant. I'm familiar with conditional formatting of this type. What I want to do more specifically is to add an icon. Conditionnal formatting offers some bullets, flags and other icons, but they only work with numbers. You cannot use them with texts or, in my case, with references to other cells (it's the cities I need to have flagged, based on continents).
    Thanks for the tip though.

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to flag list of cities based on continent?

    Create a VLOOKUP TABLE with a value for each continent. and enter a formula like this in column C:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy down the length of your data.

    You could alternatively use a LOOKUP formula like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This will produce numbers that enable you to use the Icon Sets in Conditional Formatting.

  5. #5
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: How to flag list of cities based on continent?

    You suggest to add a new column, do I get you right? I hoped to be able to have the cities flagged in the same cell.
    Actually, the cities was just an attempt to simlify things that might have worked the opposit way. I have a list of clients and I want to flag those overdue... I should have said it this way in the first place - sounds so much more obvious.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: How to flag list of cities based on continent?

    Yes, this would be in a new column. Unfortunately, the Icon Sets are limited in nature.

    If you don't want to show the value associated with the icon, you can hide the values and show only the icons. This is done in the Conditional Formatting, Manage Rules area. Select the rule, click on Edit Rule and select Show Icon Only.

  7. #7
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: How to flag list of cities based on continent?

    I try to avoid using extra column, it would indent the clients' names and I need to save space. So i want the result look something like this

    Prague
    Berlin
    o Moscow

    rather than (the dots simulate the indent):

    ...Prague
    ...Berlin
    o Moscow

    I also was considering using an extra leading character or symbol. But this would be a connected string and I don't know how to change the font to the leading character of such a string, let alone depending on the first character's value.

+ 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