=> Conditional Formatting limited to 3 conditions

[Rhonda Fischer]

Hello,

Based on my query for 'Trailer Status' I would like
this field to appear in colour where four different
status' occur, however the Format - Conditional
Formatting is limited to three. How can I change this?
Is there some code I can use instead.

Thank you kindly for your suggestions.

Best Regards
Rhonda

 

[Stephen Lebans]

Do you mean that you simply need more than 3 seperate criteria to be
evaluated? If so then you can call a function to be evaluated for each
row by Conditional Formatting which will simulate unlimited criteria.
For sample code see:
http://www.lebans.com/conditionalformatting.htm

If you require more than 4 colors(preset FormatConditionas objects) then
this is not possible.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.