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 -

EXTENDE
EXTENDE, optimize your NDT inspections projects thanks to simulation.

629 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

Wireless TOFD scanner

Quick, accurate and highly reproducible welds testing. The System operates wirelessly and is compat
...
ible with any type of Windows based Laptop, Desktop or Tablet.
>

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

Varex Imaging Large Field of View (FOV) Digital Detector Arrays (DDAs)

A larger FOV DDA can reduce the space and volume of the X-ray inspection system on the factory floor
...
, enable faster scanning times, better throughput and better resolution images at a lower dose. Customers can also save time and money. With these benefits in mind, Varex Imaging has designed a family of large FOV detectors (4343HE, XRD 1611, 4343DX-I, 4343CT) for our industrial imaging customers.
>

Alpha Pro Digital Radiography System

The Alpha Pro digital X-ray system is the ideal system for your NDT \r\nneeds, as it offers amazin
...
g 16 bit images which enable the highest \r\nlevel of detection and identification of hairline cracks. While weighing only 3kg (6.6lbs), this panel has the largest imaging area: 35 X 43 cm (14X17 in).
>

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