Hi @Rahul_Analyst,
So this can be done, but it's quite a faff to get it to work.
I've made a very crude example below that may well break if you try it with another sheet but it should give you some ideas if you want to persue an Alteryx based method.
If you read an excel file as a .zip you can access all of the different xml that makes up your document. One of these contains style information including which cells are coloured.
Here is my hideous test workbook I made -
As you can see there are various colours across rows, columns or just individual cells.
At first I read in the file as normal, but including the filepath.
The bottom strand just takes the filepath and repurposes it for use in the macro where it will read xml.
The macro takes the xml and identifies from it the cells that are coloured. I've done this in a very quick and dirty fashion so it doesn't tell you what the colour actually is, just that it has a colour and what number excel is using internally to keep track of it. You could get the actual colour but that would have taken some more messing around with the xml which i didn't want to bother with!
The macro output table is given the headers of the input data, then joined on. The additional columns basically tell you that the cells are coloured.
0 is no fill, numbers are given depending on the order in which they are first applied in the workbook (i think) - either way they are consistent.
You end up with this -
So if I wanted the yellow cells in column A I would filter "A_Colour" to 2.
It's a bit of a mess but it might give you a jumping off point to develop something better.
Regards,
Ben
