conditional formatting

Question

Hi,

I have a form that has 46 records. Each record represents each row in my table.

Field1 has a different date in it for all 46 records.

In the forms view in access, the field1 box will have conditional formatting applied to it.

I would like each record in the form to have different conditional formatting rules applied to it. I know that I can only have 3 conditions for every box, but is there a way to get around this using code since I need 46 conditions.

Thanks in advance for your help!!

Jcwishart