how do i use more than 3 conditional formats settings???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew - 19 Dec 2005 03:03 GMT

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

Reply to this Message

Biff - 19 Dec 2005 03:42 GMT

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

>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
[quoted text clipped - 3 lines]
> thank you
> Andrew Hansen

Reply to this Message

Gord Dibben - 19 Dec 2005 18:26 GMT

Andrew

For 10 you would need VBA.

If acceptable, post back for example.

Gord Dibben Excel MVP

>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

Reply to this Message

Andrew - 21 Dec 2005 01:29 GMT

i would be look at the use of max 20 and if i have to use a VB script is
there any programs out they that have already been set up???

thank you
Andrew hansen

> Andrew
>
[quoted text clipped - 10 lines]
> >thank you
> >Andrew Hansen

Reply to this Message

Gord Dibben - 21 Dec 2005 20:32 GMT

Andrew

Bob Phillips has built an add-in that will allow up to 30 CF's

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

Try it out.

Gord

>i would be look at the use of max 20 and if i have to use a VB script is
>there any programs out they that have already been set up???
[quoted text clipped - 16 lines]
>> >thank you
>> >Andrew Hansen

Reply to this Message