where expertise comes together - since 1996

Web's Largest Portal of Nondestructive Testing (NDT)
Open Access Database (Conference Proceedings, Articles, News), Exhibition, Forum, Network

All Forum Boards
Technical Discussions >
Coloring cells for MS excel thickness survey report
Career Discussions
Job Offers
Job Seeks
Classified Ads
About NDT.net
Articles & News

593 views
03:28 Jul-23-1998
Mike Plant
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.



    
 
01:49 Jul-24-1998

U. Mletzko

R & D, Retired
Germany,
Joined Nov 1998
89
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






    
 
01:32 Jul-25-1998
William Friedman
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



    
 


© NDT.net - The Web's Largest Portal of Nondestructive Testing (NDT) ISSN 1435-4934

Open Access Database, |Conference Proceedings| |Articles| |News| |Exhibition| |Forum| |Professional Network|