Applying Excel Data to Create Heat Map

Hi,

I am working on creating a heat map of lighting usage. I have an excel file with the data of watts/square footage of each building and have the conditional formatting giving me the color representing each building.

I also have a map of the entire facility that is already made in MicroStation. How do I apply the data and coloring of the excel file to color each building according to the color represented in the excel file? (All buildings in the drawing are currently under the same level and are the same color.). The drawing is a 2D drawing so I can't access the datagroup definition tab.

If possible I would like this to be a link of some sort so the data can be refreshed and the map can still be relevant as the data changes.

Thanks