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

Question

Sir,&nbsp;&nbsp;Two queries have mentioned in "Queries" sheet of the attached file. Kindly provide solutions

sergeibaklan · Answer

Hi,
&nbsp;
In general it could be done by Power Query, see PQ sheet in attached

vasudev_d_n · Answer

Dear Sergi,Thanks a lot!!!In my Excel Application, Power Query app&nbsp;was not available. So i could not able to get the desired output. Also give me the best link for learning Power Query app.&nbsp;Thanks in advance...

sergeibaklan · Answer

Power Query is built in into 2016. For earlier versions you may download as add-in from here&nbsp;https://www.microsoft.com/en-us/download/details.aspx?id=39379&amp;CorrelationId=67016d64-9b83-49d3-b538-3a3fbd2030ea
&nbsp;
As for the introduction - it's a lot of resources, just google "power query..". You may start from&nbsp;https://support.office.com/en-us/article/power-query-overview-and-learning-ed614c81-4b00-4291-bd3a-55d80767f81d

Forum Discussion

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

Share

Resources