See Chip Pearson's site for working with colors code.
http://www.cpearson.com/excel/colors.htm
Gord Dibben Excel MVP
On Mon, 1 Nov 2004 09:35:22 -0600, ExcelMonkey
wrote:
I am building a colour key for a a model to note which cells have bee
imputted by which people. As a result I want to set up say 6 colours
in a legend and then run a macro to count the existence of each colour
in the model. A coutif based on colour if you will.
Is there an information function in Excel which will return the colour
format of a cell. For example:
Info(A1) = 2 [2 meaning a particular colour format which is evident in
cell A1]
Or should I just go the VBA route with a custom function since I will
be building a routine to count the colours anyway?
Thanks.