Excel has no worksheet function that will do this.

How did the cell get its shading?

Manually or by Condtional Formatting?

See Chip Pearson's site for user defind functions to cover the above

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

Note the caveat about Conditional formatting and the link to another page.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 10:38:01 -0700, Ray wrote:

How can I determine the color of cell shading using a function or expression?