On Sun, 03 Sep 2006, tjack13 wrote:

I've been given a workbook to convert into Access. The users have
manually formated row colors to indicate the status of an order. Is
there a way to set the value of a cell depending on its color, as in
=IF(COLOR=GRAY,CANCELED,)? Of course I have about 6 colors to deal with
,is there a way to nest this?

Amd one more thing. The .Interior.ColorIndex ignores any conditional
formatting. It always returns the core color.

Don <www.donwiss.com (e-mail link at home page bottom).