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

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

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

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

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

Andrew

For 10 you would need VBA.

If acceptable, post back for example.


Gord Dibben Excel MVP

On Sun, 18 Dec 2005 19:03:02 -0800, Andrew
wrote:

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

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

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

"Gord Dibben" wrote:

Andrew

For 10 you would need VBA.

If acceptable, post back for example.


Gord Dibben Excel MVP

On Sun, 18 Dec 2005 19:03:02 -0800, Andrew
wrote:

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

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

Andrew

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

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

Try it out.


Gord

On Tue, 20 Dec 2005 17:29:02 -0800, Andrew
wrote:

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

"Gord Dibben" wrote:

Andrew

For 10 you would need VBA.

If acceptable, post back for example.


Gord Dibben Excel MVP

On Sun, 18 Dec 2005 19:03:02 -0800, Andrew
wrote:

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