Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

10. What is meant by a feed rate?

Answered: 1 week ago

Question

1. Identify six different types of history.

Answered: 1 week ago

Question

2. Define the grand narrative.

Answered: 1 week ago

Question

4. Describe the role of narratives in constructing history.

Answered: 1 week ago