Hello,
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?

Thanks,

Todd