where expertise comes together - since 1996 -

The Largest Open Access Portal of Nondestructive Testing (NDT)

Conference Proceedings, Articles, News, Exhibition, Forum, Network and more

where expertise comes together
- since 1996 -

681 views
Technical Discussions
Mike Plant
Mike Plant
03:28 Jul-23-1998
Coloring cells for MS excel thickness survey report

I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
Thanks in advance.


 
 Reply 
 
U. Mletzko
R & D, Retired
Germany, Joined Nov 1998, 89

U. Mletzko

R & D, Retired
Germany,
Joined Nov 1998
89
01:49 Jul-24-1998
Re: Coloring cells for MS excel thickness survey report
: I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
: Thanks in advance.

Using Excel 97, this is a built-in feature. It is in menu ***Format***. In German language the menu item is ***Bedingte Formatierung***, in English it might be ***Format with conditions*** or similar.

Best regards
Uli Mletzko, MPA,University of Stuttgart, Germany





 
 Reply 
 
William Friedman
William Friedman
01:32 Jul-25-1998
Re: Coloring cells for MS excel thickness survey report
: : I have recently completed a UT thickness survey of a vessel and have written up the results in micrsoft excel. I wish to color code the cells according to their thickness to highlight thin areas. Does anyone know how this is done, maybe by macro?
: : Thanks in advance.

If you have an earlier version of Excel then you need to use a macro. You can use the RECORD MACRO mode to define the code for setting the color by using the Format Pattern selections. Then you will have to create a Do Loop in visual basic with an If statement to check every cell in your image.

Good luck, Using Visual Basic is not trivial.

Bill Friedman


 
 Reply 
 

Product Spotlight

Magnetic X-Ray Pipeline Crawler 6''-60''

Suitable to work in 6''-60''diameter with speed of up to 18m/min, Max. moving diatance 5 kilometer
...
s and provide the efficient inspection of the pipeline.
>

iProbe - USB Phased Array Probe

Turn your PC, Laptop or Tablet into a powerful 32:64 Phased Array system with our USB powered Phas
...
ed Array iProbe and inspection software package. Perform affordable weld inspection and corrosion mapping inspections with this powerful but small system. The probe has a 100V pulser, 8K PRF, dual axis encoder input and achieves outstanding signal quality.
>

OPBOX with standard software is able to do all types of inspections and measurements: flaw detection in welds and materials, scanning of objects, testing composite materials, forged and moulded pieces, many UT inspections, measurements of properties of ma

Typical applications: UT measurements with pulse technique, Measurement of thicknesses also at hig
...
h temperatures, Measurements of properties of materials, including fluids and gases We are delivering a standard version of the software (for any Microsoft Windows up to 10 x64 with Microsoft Hardware certification report Approved) and for special needs: SDK with ready to use examples for LabView, MATLAB x64, C++ wrapper for dll, Python and Linux., and also low-level description of how to control our devices directly from any USB tools
>

High-performance Linear Phased Array Probes

Available to order from stock in a range of 5MHz – 7.5MHz and from 16 to 64 elements. Designed w
...
ith piezo-composite elements, Phoenix phased array probes provide high-resolution imaging to maximise sensitivity; accurate ultrasonic detection and sizing of defects in welds; and effective corrosion mapping. Housed in a rugged stainless steel case for on-site industrial NDT applications.
>

Share...
We use technical and analytics cookies to ensure that we will give you the best experience of our website - More Info
Accept
top
this is debug window