=> Conditional Formatting limited to 3 conditions

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
R

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
 
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.
 
Back
Top