R
Rob
Hi
I have a table where I want to record any number of items that I pass on to
people by putting their initials into a cell..
Whenever I put the initials of a person into a cell, I want the background
colour for the cell to change to red and then have a "Total" cell which adds
up how many cells have changed colour, ie how many items have I passed on.
JP TC RH BJ SH Total
5
I have used in the past the following
=SUMPRODUCT(--(ColorIndex(B2:G3)=2)) which worked ok for a while but now I
cannot get it to function properly.
Also I have upgraded to Office 2010 so is this why it will not work.
Any help appreciated.
Regards, Rob
I have a table where I want to record any number of items that I pass on to
people by putting their initials into a cell..
Whenever I put the initials of a person into a cell, I want the background
colour for the cell to change to red and then have a "Total" cell which adds
up how many cells have changed colour, ie how many items have I passed on.
JP TC RH BJ SH Total
5
I have used in the past the following
=SUMPRODUCT(--(ColorIndex(B2:G3)=2)) which worked ok for a while but now I
cannot get it to function properly.
Also I have upgraded to Office 2010 so is this why it will not work.
Any help appreciated.
Regards, Rob