I see! This fills the correct shapes with the colors called out in code, which is great.
With my first bit of code at the top of this thread, every county called out was turning red, not red, yellow, or green based off its corresponding date in column C of WS1. This is where I was having trouble initially, but I like the way your code handles the fill color better I think. Now I just need to utilize correctly!
That said,...
gnider
Last Activity: Sep 29 '15, 09:02 PM
Joined: Apr 24 '15
Location: Minnesota
-
zmbd,
The shape is odd in that it seems to have multiple "layers" when first imported into Excel: one layer as one big shape and the second layer "hiding" behind the first layer. I essentially deleted the first large layer, enabling me to play around with, move if I choose, or fill each individual shape in the second layer.
So you answer your question it isn't really one giant shape, or it doesn't have...Leave a comment:
-
Thanks for your reply, zmbd!
I've attached a .zip containing a .xlsm with the inserted .wmf I am using. The .wfm can also be found at http://www.mngeo.state.mn.us/maps/USmaps/index.html and is called "MN.WMF." I will attached my full workbook if it's determined I can. That maybe the most helpful.
Also to answer your question, by highlighting the shapes I mean fill color, really, the manual method being selecting...Last edited by zmbd; Apr 27 '15, 01:10 AM. Reason: [z{please understand, we don't normally open unrequested attachments, I usually work in a secured environment that prevents that.}}Leave a comment:
-
EXCEL Q: How to Color Shapes Based off Date Ranges in Various Cells?
OK first off hello! I am new to these forums and - though I dabbled a bit in Basic when I was younger - new to programming in general. I have searched using Google rather extensively but cannot figure out how to do what I'm attempting...pe rhaps because I am having a hard time applying programming principles because I am new to macros and VBA.
I use Excel (2013) quite a bit to help organize large amounts of info, but am starting to...
No activity results to display
Leave a comment: