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