From: Keith Wilby on
"kevcar40" <kevcar40(a)btinternet.com> wrote in message
news:a362a623-ad8e-42f1-94b4-47e4fd471d10(a)m16g2000yqc.googlegroups.com...

"conditional formatting only allows 3 conditions,i need 8"

That's only true of using the CF menu interface, you can code for more.

Keith.

From: kevcar40 on
On 12 Jan, 14:23, "Keith Wilby" <h...(a)there.com> wrote:
> "kevcar40" <kevca...(a)btinternet.com> wrote in message
>
> news:a362a623-ad8e-42f1-94b4-47e4fd471d10(a)m16g2000yqc.googlegroups.com...
>
> "conditional formatting only allows 3 conditions,i need 8"
>
> That's only true of using the CF menu interface, you can code for more.
>
> Keith.

thanks to all
i have worked it out it works a treat
thanks again

kevin