View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
-Bryan[_2_] -Bryan[_2_] is offline
external usenet poster
 
Posts: 15
Default 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