Conditional Formatting - Three Condition Limit

[razorking]

I have found some posts on this and a few things doing a google search. But it is one of those situations where I am not finding exactly what I hoped, possibly for good reason but, here is my question:

I would like to use conditional formatting in a report but, the barrier is that there is a limit of three conditions. I suspect that this can be overcome by use of VBA. Problem is I don't have those skills. If anyone knows how to do this, and perhaps would be willing to look at the attached example db, and add a little code and repost - I would appreciate it.

Thanks!

 

[Galaxiom]

http://msdn.microsoft.com/en-us/library/aa139965(office.10).aspx

 

[razorking]

Well thanks for the reply. That might be too difficult for me to use in my application - but I mmight try to use it if I get more time and am bored.

 

[gemma-the-husky]

a report is different - surely in the detail sections print or format event you can test and format anyway you want

a continuous form is completely different to a report