how to convert excel background colors cells to a data table?

[Anonymous]

Hello everybody,

I need some help to convert a excel planning to a data table.

My main problem is to convert the background color cells to data. The color stand for different projects.

 

Thank you guys for your affords.

[v-chuncz-msft]

@Anonymous,

You may take a look at link below.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/converting-color-coded-cells-into-numbers-excel/b70a2c9e-9927-49c8-a299-48d39ac8180f

[Anonymous]

Is this possible in power bi? Or is it better too work with macro's in excel?

[v-chuncz-msft · Accepted solution]

@Anonymous,

Not yet supported. Besides, you may take a look at Conditional table formatting in Power BI Desktop.