Are there any function that can return information on the color format of a
cell?

Have a look here

http://www.cpearson.com/Excel/colors.htm

Mike

"nc" wrote:

Are there any function that can return information on the color format of a
cell?

CELL("color",reference)

returns 1 if the cell is formatted in color for negative values; otherwise
returns 0 (zero).

"nc" wrote:

Are there any function that can return information on the color format of a
cell?

Function GetColorindex(rng as Range)
GetColorindex = rng.Interior.Colorindex
End Function

but as a colour change triggers no events, it will not update if you change
the colour.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"nc" wrote in message
...
Are there any function that can return information on the color format of
a
cell?