+ Reply to Thread
Results 1 to 5 of 5

Colouring the countries with their flags

  1. #1
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Colouring the countries with their flags

    Hello,

    I would like to ask some advice regarding that how is it possible to colouring the countries with their flags? For instance I would like to see on the shape of France the flag of France. And so on regarding the all european countries.

    I have attached a sample file.

    Thanks in advance the reply!
    Attached Files Attached Files

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Colouring the countries with their flags

    provide me a list of countries and their respective colors...

    and also upload a file again after writing each countries name in the picture...

    hopefully after that I can make a code to do it automatically..


    Don't forget to click *

  3. #3
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Colouring the countries with their flags

    In the attached file you can find three example countries with their flags and positions on the map.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Colouring the countries with their flags

    I'm not convinced it's necessary to use code? It'll only take 5 minutes to do it manually. Copy the flag onto the clipboard. Select the shape corresponding to the country; right click & select format shape; fill, picture, clipboard. Repeat for the next country...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Colouring the countries with their flags

    ... the only slight complication is for the UK, where (before pasting), you need to select our four nations (England, Scotland, Wales & Northern Ireland); group them & then proceed as previously.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Colouring the countries with their flags

    Hi Glen,

    This is very simple method! Thank you for that you shared this idea!

+ 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. Operating Flags
    By dems in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 10:21 PM
  2. Macro for Error Flags
    By galatians220 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2012, 07:27 AM
  3. Binary Flags in Excel
    By ste_mulv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-16-2009, 09:59 AM
  4. Manipulating Date Flags
    By activomate in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2008, 03:28 AM
  5. Boolean Flags - How to Set?
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-06-2008, 01:19 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