Bringing font and cell colors with power query

[harry1605]

Hello,

I have sprints every 2 weeks for the next 14 weeks.  As part of each sprint we get a set of files where number varies depending on sprint.

I am able to get the data from all the files and combine the data into one file.  However, I would also like to take the colour of the font.  The reason for this is the file contains updates which are required with the text in red.  So by having the font colour I can specifically see the updates that are required.  Can someone assist me with determining how I can do this using power query

Thank you

[v-junyant-msft · Accepted solution]

Hi @harry1605 ,

Power Query does not have the ability to change fonts and cell and font colors, and even if your data source has fonts and colors set, they are not reflected in Power Query, neither the Power BI Desktop.
As a workaround, you can merge all the data and import it into Power BI Desktop, then create a table visual or matrix visual object and use conditional format to color the cells.
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harry1605]

Thanks Dino - I do not have access to power BI so have scripted a solution