I can help you on the first part -- Conditional Format. Let's say we use A1
(Target), B1 (Reported) and C1 (Difference). Click on C1, then FORMAT
CONDITIONAL FORMAT

Choose "Formula Is" instead of "Cell Value Is"

Type in: =AND(C1<"",OR(C1/A1 < -0.1,C1/A1 0.1))

After typing in formula, click on FORMAT (in the conditional formatting
window and the FONT. There is a place to choose the color you wish to
display if the criteria is met.

Les




"JoePineapples" wrote:


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




--
JoePineapples