Hi!

is there any way other than using a vba script???

No.

There is an add-in that allows up to 30 conditions but the add-in uses VBA
programming.

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

Biff

"Andrew" wrote in message
...
i would like to see if i would be able to use more than three conditional
format because i will be looking to use 10 is there any way other than
using
a vba script???


thank you
Andrew Hansen