Heat Maps Macro.zip


This macro updates the regional maps in a map collection according to defined colour codes.


1. Enter the Patent count for each of the Jurisdiction in the 'Patent data' sheet.

2. Now use these minimum and maximum values to set ranges of patent count, in the 'Range Table'.

3. After setting the ranges, assign different color codes corresponding to the ranges by changing the background color of cells in column L.

4. Now press the button 'Color code map' to get the World map color coded.

5. Those jurisdictions with data not provided will be marked in 'Black' color and white colored for "0"(zero) values.


Highlighting the regions with the interactive colors in a map collection as shown below.

Copyrights 2020, www.expertsupdates.com