Firstly, I think you intended to say AND, not OR. [With OR, the condition
would always be satisfied.]
Secondly you don't need the IF.

Try
=AND(A1=.96*$H1,A1<=1.04*$H1)
--
David Biddulph

"BlueWolverine" wrote in message
...
For Excel 2003

Select the cells you care about (A1 to G1).
Go to Format -- Conditional Formatting.
change the deafult from "Cell Value is" to "Formula is"

the formula you want is going to be
=if(OR(A1=.96*$H1,A1<=1.04*$H1),1,0)
Then go into the Format button and change the settings so that the format
is
what you want it to look like when the value hits +/- 4%.

hit ok and it should go.

YOu can add up to 3 conditions in Excel 2003.

You can do SO much more with EXCEL 2007 it's unbelievable but I don't have
it in front of me and I don't have it memorized.
Good Luck,

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


"-Bryan" wrote:

I have created a form to track moisture content in a material. Depending
upon
the material, a different standard is set, and when the moisture content
reaches within 4 points of the standard, the job is done.

Readings are entered daily in a row, and the standard is entered at the
end
of the row. Is there a way to have the font color change when the data
entered is +/- 4 points of the standard?

Basically, the daily readings are input in A1,B1,C1...G1, and the
standard
is entered in H1