Hi all.  I have a workbook that contains over hundred rows.  Each row has a
colour indicating what worksheet it relates to.  In a column at the end of
the worksheet I would like to add a number that represents that colour so I
can then filter by number (tried filtering by color but that was too much
hard work).  The workbook changes daily so doing it manually is a pain in the
backside.  I have searched the net and found VBA codes (which I would prefer
not to use if possible) and came across this
To get the colorindex of a specific cell, simply use  (this is from
xlDynamic.com)
=ColorIndex(A1)
I paste this into a cell and reference it correctly but it keeps coming up
#NAME? any ideas.