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 -
311 views
Technical Discussions
Jairo Humberto Guzman
Jairo Humberto Guzman
05:55 Jul-27-1998
Re: Coloring cells for MS excel thickness survey report

I send a macro example to color cells in excel
sorry These example is in spannish, but you can change the colors and value range
good luck


' Macro1 Macro
' Macro grabada 27/07/98 por Red Nacional de Datos
'
'
Proced Macro1()
Para Cada d En Rango(Rango("A1"), Rango("d1").Desviar.Fin(xlAbajo))
Número = d.Valor ' Inicializa variable.
Seleccionar Caso Número ' Evalúa Número.
Caso 1 Al 2
d.Fuente.ÍndiceColor = 5
Caso 2 Al 4
d.Fuente.ÍndiceColor = 1
Caso 5 Al 6
d.Fuente.ÍndiceColor = 2
Caso 7 Al 8
d.Fuente.ÍndiceColor = 3
Caso 9 Al 10
d.Fuente.ÍndiceColor = 4
Caso SiOtro
d.Fuente.ÍndiceColor = 6
Fin Seleccionar
Siguiente
Fin Proced



 
 Reply 
 

Product Spotlight

NDT.net launches mobile-friendly design

NDT.net has revamped its website providing a mobile-friendly design.The front page received a comp
...
letely new design and all other sections are now reacting responsively on mobile devices. This has been a major step to make our website more user- friendly.
>

IRIS 9000Plus - Introducing the next generation of heat exchanger inspection.

Representing the seventh generation of the IRIS system, the IRIS 9000 Plus has nearly 200 years of c
...
ombined field inspection experience incorporated in its design. This experience combined with a strong commitment to quality and a history of innovation has made Iris Inspection Services® the undisputed leader in IRIS technology.
>

UCI Hardness Tester NOVOTEST T-U2

UCI hardness tester NOVOTEST T-U2 is is used for non-destructive hardness testing of: metals and
...
alloys by scales of hardness: Rockwell (HRC), Brinell (HB), Vickers (HV); non-ferrous metals, alloys of iron etc., and using five additional scales for calibration; with tensile strength (Rm) scale determines the tensile strength of carbon steel pearlitic products by automatic recalculation from Brinell (HB) hardness scale.
>

New PHAsis module for longitudinal weld seam inspection

PHAsis® Phased Array manual ultrasonic spot weld inspection device is now ideally suited for test
...
ing of longitudinally welded seams (e.g. Arplas® seam, short line seams) with a length of 3 to 12 mm.
>

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