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

[cbouichi]

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]

@cbouichi,

You may take a look at link below.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/converting-color-coded-cel...

[cbouichi]

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

[v-chuncz-msft · Accepted solution]

@cbouichi,

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