Change object surface colour based on excel data


I would like to have the colour of an object in sketchup change based on the value of data in excel workbook. Can someone please advise as to how I can do this? Is it even possible? Any resource suggestions?

Thank you