yEd's Excel import only imports the Excel cell data. If you want to have different colors in the resulting graph, you need to have a way to derive those colors from data in the Excel sheet. E.g. the simplest way would be to have a distinct color column in the Excel sheet with color names/values. Using yEd's properties mapper it is then possible to automatically color the elements in the imported diagram depending on the corresponding color value.
