Highlight Variances at aggregated level

[posywang]

Hi,

I got a user request to highlight cells where Capacity and Demand do not match. The problem is that once I expand next column (ResourcePool in attached example file), it highlights every cell even Capacity and Demand match. Can you please review the attached file and let me know how to fix it? Thanks!

[posywang · Accepted solution]

if(sum(total <Dim,Mth> Capacity)<>sum(total <Dim,Mth> FTE),RGB(255,255,176),white())