1) look he
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

2) get XL2007

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"WT" wrote in message
...
Is there any way to have more that 3 condition in conditional formating?
--
Thank you