Running Excel '03, I have a worksheet, which is updated by many users
involved in establishing new contract types. Each line represents a new
contract opportunity. Basic information about each specific contract is keyed
in columns A-L. (M) is blank, and N-AH are columns for completion dates on
specific process stages.

I have (9) different contract types, which are denoted in column J. Based
on the contract type, I need to color in different cells in the N-AH range,
to indicate that these columns, would need to be filled in with dates of
completion.

I am somewhat familiar with formula building, but know that I am limited on
the number of "IF" statements that could be nested. I gave speculation about
creating option buttons, that would connect with macros, to select/color the
specific cells in N-AH, but don't know if this is the best solution.

Does anyone have any suggestions about how to accomplish this? This is a
very high profile project for our company, and all assistance is appreciated.


TIA,
Sandi