I have 2 large (col 1500 x row 180) arrays. Each col = a product. Product compositions change so cells in my updated array change colour if the original data in the array below is different. Because the array is so large I might miss a difference that is 'off screen', so I'd like the top row to change colour if ANY cell the rows beneath is different.

1 solution is to have a 3rd array when any cell to cell difference = 1 and so a sum()>0 would trigger a warning that somewhere there was > 1 difference.

Is there a neater solution? Eg. I'd wondered about using if(or(...... but that would be tedious task + I'm not sure if there's a limit to how many OR's are permitted.