When a complex condition exists, we should have additional conditions upon
which to format a result. For example, in the event that a range is from:

1-10 white color
11-20 blue
21-30 green
31-40 orange
41-50 red

etc.

Alternatively, to enable the following construct:
If a value is found in an array, format type 1
If a value is found in a different array, format type 2.
etc.

In the event that a value is found in more than one array, the first one
listed will take effect.

I am not sure if you are asking a question or making a statement, but maybe
this will help you
http://www.xldynamic.com/source/xld.....Download.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Danny" wrote in message
...
When a complex condition exists, we should have additional conditions upon
which to format a result. For example, in the event that a range is from:

1-10 white color
11-20 blue
21-30 green
31-40 orange
41-50 red

etc.

Alternatively, to enable the following construct:
If a value is found in an array, format type 1
If a value is found in a different array, format type 2.
etc.

In the event that a value is found in more than one array, the first one
listed will take effect.