more than 3 conditions formatting ??

[accesscomthomas]

seems that conditional formating is very nice in Access2000+ , BUT how can I define a conditional format with more than 3 conditions ??? In fact, I have six colors for the user to select in a combobox , any idea ?

Thanks

 

[CoderGeek]

Any luck on how to create dynmatic conditions

here is my problem I just want to change the background color of one of my columns based on the changes of another column I.E. to show the changes in sizes hilite the color of the column to show it changing