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.
Thanks.