Forum Discussion
Detect colored fonts in PowerQuery
Hi medmbchr1989
Unfortunately it is not possible to do the functionality you are looking for in power query.
https://answers.microsoft.com/en-us/msoffice/forum/all/preserve-text-formatting-with-query/c17723d7-26e2-42ce-88ac-62fa0c66aba7
If the requirement is to run Macros on files without opening the file try running VBscripts but expertise on the technique is beyond this forum.Thanks and regards
hi medmbchr1989
Power Query can't do that. It can read the text but not the formatting so the differentiation as a text must exist in the data source.
danextian the differentiation doesnt exist on the data unfortunately, i have more than a 1000 files each with 100k+ lines
If that is an excel file, you can write macro to return the color in a separate column which is already outside the realm of this forum. Try this prompt in ChatGPT.
macro in excel to return the color of a textAs I said I have +1000 excel files, cannot apply a macro to each file separately unless there is a way to do so without opening the files.
