US States - Conditional Color Formatting?

[Karthik-Excelsior]

Hi Excel experts,

I've a list of US States with the number of units sold in each of the states like this https://docs.google.com/spreadsheet/ccc?key=0Ao7RzFobcTErdEV6UHB0bGtpdUdoZ1lFRUJ4bWIzMFE#gid=3

I would like to highlight the states based on the number of units sold. For eg. if a particular state has high sales number, it should be in GREEN, average - YELLOW and below average - RED

Any help is much appreciated here.

(P.S. This was possible in Google docs., but I couldn't replicate it on Excel)

Thanks,

Karthik

 

[lmvk99]

WOOOW!!! Gotta love google So this interactive map charts thingy is not a standard feature in excel. But the good news is you can re-create with a bit of effort and some basic macros. Try something like this (yell if you get stuck on anything):

http://www.databison.com/index.php/6-easy-steps-to-make-interactive-map-chart-in-excel/

Otherwise I am sure you can buy an add in for the US map to save time.

Good Luck!

 

[AlphaFrog]

Here's another link you may find useful...
http://www.tushar-mehta.com/publish_train/xl_vba_cases/0301-dashboard-conditional_shape_colors.htm