Thanks for this Kay,

Will each use who wants to view the spreadsheet need to download that same
add-in?


"Kay" wrote:

There is a tool on the net called CFPlus which lets you use loads.

Try out www.xlDynamic.com

"rob curtis" wrote:

Is it possible to have more than 3 conditions using conditional formatting?

I am dealing with text and not numbers which makes it a little harder to
manipulate. I want up to 10 conditions.

Can anyone advise? Cheers, rob