Conditional Formatting

[Jul]

I have what I hope is a simple question. I have a form, in which various people have to use to enter data each day, several times a day. I have been experiencing a lot of errors in their entries and was hoping I could use some conditional formatting to make things stand out to them when they enter inaccurate data. The form is quite large and there really isn't any set value that should be going into the different fields. It would be idea if I could give a range for their data in each of the various fields, and if they are out of range, the box would fill in with red to make it stand out. Does anybody have any idea how I can make this work? I have tried a few times over the past few years, but haven't had much luck. Thanks for your help!

 

[georgedwilkinson]

Right click on the field and select "Conditional Formatting".

Let us know if you run into problems.

 

[Jul]

The issue is, the fields I want to conditional format, are based on another table and changes with different product types.

 

[sphynx]

Can you not limit your user data input via combo or list boxes rather than text boxes? This would negate the need to flag up there errors