Changing font color when goal is reached
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
|