I would test for the underlying condition - i.e. the one that is driving the formatting - It's less likely to break on different version of excel.
I have a count for those cells in a column that are "wrong". What I want (and I know you can do this on a pivot but can't do pivots for 32 centres etc etc) is to say
this column has 32 errors in it for this centre. Which records are this? What is their unique ID number (from column C).
Dear God
It's me Damo.
Why can't my developer team see that this is important? Why do I have to do it myself? Why do I have to ask outside consultancy agents?
I have a count for those cells in a column that are "wrong". What I want (and I know you can do this on a pivot but can't do pivots for 32 centres etc etc) is to say
this column has 32 errors in it for this centre. Which records are this? What is their unique ID number (from column C).
Dear God
It's me Damo.
Why can't my developer team see that this is important?
Why do I have to do it myself?Why do I have to ask outside consultancy agents?Love
Damo