On Jul 15, 6:05*pm, Gord wrote:
ColorIndex is not a native Excel function.
I would suggest you had an add-in or personal.xls with that UDF
When you upgraded, you did not bring that with you.
See Chip Pearson's site for some code and a downloadable workbook with
all the colorindex functions.
http://www.cpearson.com/excel/Colors.aspx
Gord Dibben * *Microsoft Excel MVP
On Fri, 15 Jul 2011 23:27:19 +0100, "Rob"
wrote:
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.