Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Is there function, marco (VBA) or build in program excel to color columns I thur J automatically from upper and lower limits in column e
Is there function, marco (VBA) or build in program excel to color columns I thur J automatically from upper and lower limits in column e and f.
Say if the excel caught a test peice that fail, the measurement would turn red, stating it fail or turns green if the measurement pass
& Cut ER Copy Arial General Paste Conditional Format as Neutral Formatting Tab:le Calculation Check Cell nsert Delete Fonmat Sort E Format Painter Clear- Styles QTY DIMENSION SPECIFICATION SPLCIFICATION/LIMITS TEST DATE TESTED MEASURLMENTS (DATA) Length Length Length Diameter Diameter Diameter Diameter Diameter 432.50 167.00 44.00 33.50 33.50 30.30 30.30 30.30 OK NOT OK not ok not ok not ok not ok not ok 0 0 not ok 0 0 433.00 432.00 23-Feb-18 3 433.2698 433.2877433.2893 167.20166.8023-Feb-18 3 44.00 23-Feb-183 33.30 23-Feb-183 33.50 33.30 23-Feb-183 30.4530.30 23-Feb-183 30.45 30.30 23-Feb-183 30.45 30.30 23-Feb-183 0.00 23-Feb-18 3 0.00 23-Feb-18 3 0.50 23-Feb-18 3 44.00 23-Feb-18 3 31.2031.10 23-Feb-183 35.20 34.80 23-Feb-183 35.20 34.80 23-Feb-18 3 24.55 24.35 23-Feb-18 3 167.185167.28 167.254 42.50042.500 42.500 33.28033.314 33.163 33.12733.287 33.237 30.35030.316 30.313 30.30230.300 30.309 30.245 30.212 30.228 0.057 0.070 33.50 20 9 0.094 0.055 0.065 N/A N/A 0.134 #DIV/0! #DIV/0! Length 0.70 NIA NIA 31.103 31.108 31.110 34.750 34.721 34.735 34.608 34.689 34.615 24.248 24.256 24.249 45.00 46.00 Diameter Diameter Diameter Diameter 35.00 35.00 24.35 not ok not ok not okStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started