Sorry, Gary, I can't help with this, and as Bob hasn't posted anything
for a couple of days I think he may have gone on holiday. I am sure he
would be grateful if you could contact him (via the xldynamic site) to
explain the problem you are having, and he'll get round to answering
you when he returns.

Pete

Gary wrote:
Thanks Pete,

I downloaded it but when i try to open the file. It says

Runtime error 9
Subscript Out Of Range.

Please Help.

"Pete_UK" wrote in message
ups.com...
You could download this free Add-in from Bob Phillips - it gives you up
to 30 conditional formats:

http://www.xldynamic.com/source/xld.....Download.html

Hope this helps.

Pete

Gary wrote:
Hi,

I have 7000 rows, 5 columns.

I need to highlight the entire row if the value in column 5 is X

conditional formatting is limited to 3. I may have more than 10
criterion.
i.e. X, Y, Z, A, B, C, D, E, F, G, etc etc


Please help.
Thanks