Creating a map in excel with conditional formating

[deependra]

I am a construction engineer and i think to visually record progress thematic charts might be a good idea. The monitoring part includes major activities like excavation concreting etc and I want to show them on the map + carry out some insightful informations.Is it possible in excel or shoul I use some other software.

What I want is somehting like this http://www.begraphic.com/create-custom-map-add-in-excel-and-powerpoint
Rather than making it a gantt chart it should just be a visual thing which might be done by using conditional formatting in autoshapes however VBA is not my forte and thus I am looking for some add ins or a turn around....

Regards,
DV

 

[BrianB]

As far as I know we cannot use conditional formatting in autoshapes.

However we can change colours with macros.
I suggest you start by recording some macros of changing colours etc. and go from there.