count the color cells of conditional fomatting applied in results from Pivot Table

[Vasudev_D_N]

Sir, 

Two queries have mentioned in "Queries" sheet of the attached file. Kindly provide solutions

[#2]

Hi,

In general it could be done by Power Query, see PQ sheet in attached

[#3]

Dear Sergi,

Thanks a lot!!!

In my Excel Application, Power Query app was not available. So i could not able to get the desired output. Also give me the best link for learning Power Query app. 



Thanks in advance...

[#4]

Power Query is built in into 2016. For earlier versions you may download as add-in from here https://www.microsoft.com/en-us/download/details.aspx?id=39379&CorrelationId=67016d64-9b83-49d3-b538...

As for the introduction - it's a lot of resources, just google "power query..". You may start from https://support.office.com/en-us/article/power-query-overview-and-learning-ed614c81-4b00-4291-bd3a-5...