Is there function, marco (VBA) or build in program excel to color columns I thur

Question

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 ok

Explanation / Answer

For fill the color of columns through i to j there is macro(VBA) exist.for example ->

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.