Hi All

I have a Form in excel which lets people enter monitoring information.

It has the fields Target, Reported and Difference. The Target field is pre-set, they have to enter the Reported field and the Difference field is a calculated field based on Targeted - Reported.

If this difference is more than 10% or less than -10% I would like is the following:

A. To change the font colour in the Difference text box red.

and

B. The form to open another text box (called reason) - so that they can explain the difference.

Any help would be much appreciated

Cheers

JP