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?

Yes. What you are looking for is Cells(i,j).Interior.ColorIndex =
The color indexes are integers. I'm not sure where it is documented what
they are, but you can experiment.

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