Help writing an Excel macro

jchicks · Feb 20th, 2002, 04:50 AM

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 · Feb 20th, 2002, 05:15 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 04:50 AM	#1
jchicks New Member Join Date: Feb 2002 Posts: 13	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.

Feb 20th, 2002, 05:15 AM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Have a look at conditional formatting in help, It sounds like this is what you need. Good Luck