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

YXLON Cougar EVO

Scalable small footprint X-ray inspection systems for assembly and laboratory applications. The
...
YXLON Cougar EVO series was designed to provide the "best-in- class" inspection solutions for SMT, semiconductor, and laboratory assembly applications, while maintaining a small system footprint for maximum convenience. With optimized software and hardware, these systems produce higher quality and more consistent results than other electronics inspection systems currently on the market.
>

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

XRHRobotStar

In high volume industries like automotive the requirement for a hundred percent X-ray inspection c
...
reates a bottleneck in the production. The XRHRobotStar is a fully Automated Defect Recognition (ADR) capable robot-system that allows an ultra-fast in-line inspection.
>

Sci Aps Z-Series Portable Handheld Analysers

The world’s only handheld analyzer that measures carbon content in stainless (yes even L-grades),s
...
teels, and cast irons. Also accepted for low Si analysis for sulfidic corrosion analysis, and is widely used in the power industry for Cr analysis, for flow accelerated corrosion 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