copy conditional formatting to numerous controls

[Guest]

Hi, is there a way to copy the same conditional formatting to othercontrols
on a form without having to change the control name in the conditional
formatting expression of each one after I copy it? I would like to copy the
equivalent of:
([StageRevisedEstEndYr])<1
to numerous cells, but don't want to change the control name in each one,
takes too long.

Is there a way to use the wild *, or something like that in place of the
control name?
Thanks,
Harold

 

[Guest]

I am not sure if yours is an Access question but you can change a property on
many objects in design view by clicking on the first, holding down the shift
key and then clicking on the rest. Then make your property change.