Most likely can be done but from your description it is difficult to give a "how
to" answer.

How will Excel know if "the subject applies"?

What criteria determine this and what type of option is required?

A better description of your data layout would help.


Gord Dibben MS Excel MVP


On Wed, 11 Apr 2007 07:24:04 -0700, rebeccca
wrote:

I have a large database in excel. I would just like in option in one column
where if the subject applies, you can just check a box. Is this possible and
if so, how do I do it? Thanks!