Hello all,
New here and still doing searches to maybe find this somewhere. Google was not helpful here. But I decided to post to see if someone can help me get this moving.
I have a floor plan of a data center. Lots of rectangles all on a layer showing cabinets. I need to be able to set the color of a shape based on a number in a excel spreadsheet. It will be closed and most likely closed. I do not mind a data import from a closed file as a step to keep the data refreshed as long as I can pull from the "live" data when I need to.
I would like this to be a separate layer which i can take care of duplicating the current shapes. For the reason that I can turn it on or off depending who I am presenting to. The number I am referring to can be anything from 0-35 and I would like it to be based on 4 colors.
Any help will be nice.
Thanks all
DCPro