Hi, Thanks for the reply, I have already tried this however it doesn't seem to work alongside a conditional formatting rule for the header in a pivot table. Seems to just shade the whole row and not differentiate between the cells (not due to @row because I haven't included that) Hopefully someone has found a solution to…

Hi, Does the location data include Latitude and Longitude? I notice there is only one attribute applied. Thanks