Install the VBA function at the bottom the the webpage.
--
Gary''s Student - gsnu200768


"Woodi2" wrote:

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.