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.