Extra Conditional Formatting

[cameron.scrimgeour]

I have an access form which has a subform. The subform shows some fields from a table in a database.

I have already got the maximum number of conditional formatting conditions in use, but I need another.

Can this be done in VBA?

The current formatting is like this...

number-------name-------stock
1-------------meat-------50
2-------------veg---------20
3-------------milk---------0
4-------------fruit---------101

I have formatting which alternates the colours of each row so that the rows go, blue, green, blue, green etc.

The other condition makes the row red if the stock is 0.

I need a condition to make the row yellow if the name is equal to veg.

Can this be done through some VBA code??

 

[namliam]

Nope, 4 conditionals (or 3 conditional + 1 default) is the max. Sorry