The only way I can think of is through VBA; you could add a routine that
checks your conditions and alters the .BackColor property depending upon
its output.
Attach this procedure to the control_Change event and there you go.
However, if you have lots of controls that you wish to work with, it may be
better to write a routine that tests all conditions and modifies all of the
controls; then simply place a call to this routine on the Change event of
all controls.
Not very elegant, but to be honest conditional formatting is usually used
to represent traffic lights - either red, green or amber; therefore not
usually needing more than three conditions.
You can only have 3 preset Conditions...period. You can though have a
custom function called to enable you to evaluate more than 3 conditions.
What is it exactly you need to accomplish?
--
HTH
Stephen Lebans http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
