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 -

611 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.


    
 
 
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





    
 
 
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


    
 
 

Product Spotlight

FlexoFORM™

The FlexoFORM™ solution integrates flexible phased array probe technology in a scanner to solv
...
e the challenges that come with inspecting pipe elbows. When combined with a water column, this solution can be used to collect easy-to-interpret data on elbows with diameters ranging from 4.5 in. OD up to flat and offers many benefits.
>

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.
>

NovaScope 6000

The all-digital Novascope 6000 is a portable, ultra-high precision thickness gauge for high-speed
...
thickness measurement. Novascope 6000 has unmatched capabilities and unique features including: •Superior Resolution with high contrast, high-speed color RF display •High pulser voltage •Real-time video output •Increased internal/external data storage •Programmable SetUp features •Battery & AC Powered
>

Ultrasonic tomograph for imaging of concrete structures А1040 MIRA

Applicable for concrete inspection allowing imaging of the internal structure of objects from conc
...
rete, reinforced concrete, different stones. The operation applies pulse-echo technique at one-side access to the object. The instrument is feasible for concrete inspection for searching conduct ducts, conduits, detection of foreign inclusions, holes, honeycombing, cracks and other concrete defects.
>

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