Importing excel to change colour in dynamo

excel
revit
python
dynamo
#1

Hi, hopefully, I’ve used the appropriate tags and I’m in the right section.

I am looking to change the colour of bins on a floor layout using their waste level. Green then Yellow when it reaches a certain height, then red when it passes another threshold. Similar to the image below.

So far, hopefully, shown in the images below I have managed to find scripts to change the colour of the bins with a slider, and I am able to import the excel data in separately, but I am not sure how to put them together

The excel import holds the height of waste in the bins importing both the time and height. If at all possible I would like Dynamo to loop through the levels and then change the colour accordingly when it reaches a particular height, then start from the beginning again.

Would anyone be able to point me in the right direction? I am incredibly new to Dynamo and Revit. Also, since there are five bins, I would be looking to import all 5 data sets at the same time, and then they would change depending on their own waste level.

Thank you