Help writing an Excel macro

[jchicks]

My job requires me to input measurements into a spreadsheet.Rows 'E' end 'F' hold the upper and lower tolerances for the measurements. I need a macro that will compare the data I enter into each cell with the tolerance values, and change the color of cells which hold values outside of this range. I am fairly new to Excel so any help would be appreciated!
Thanks.

 

[Paul B]

Have a look at conditional formatting in help, It sounds like this is what you need. Good Luck