uday
Member
Hi,
I am trying to find out the 0 sum values according to description (Column A).
My goal is highlighting only those cell in amount section (Column B) which are only giving me total sum value of 0. Amount could be break down separately in different cells. However the description type should be same in this case.
I can easily sort them or apply pivot table to find out the total sum value of each description type. But, I want to highlighted them with unique color, when there are giving me total sum value of 0. Others description items should be non highlighted state.
After getting the solution, I will automate this process, as I have more than 5000 line items in my final data template.
Regards,
Roy
I am trying to find out the 0 sum values according to description (Column A).
My goal is highlighting only those cell in amount section (Column B) which are only giving me total sum value of 0. Amount could be break down separately in different cells. However the description type should be same in this case.
I can easily sort them or apply pivot table to find out the total sum value of each description type. But, I want to highlighted them with unique color, when there are giving me total sum value of 0. Others description items should be non highlighted state.
After getting the solution, I will automate this process, as I have more than 5000 line items in my final data template.
Regards,
Roy