more than 3 conditional formats?

[infinity]

Hey all,

I am wondering if there is any way to set more than the limited 3 conditional formats for any given cell. Or better yet is there any way of setting it for all workbooks. Thank you in advance for your help.

Thanx Scott

[austenr]

Try this KB entry:

http://vbaexpress.com/kb/getarticle.php?kb_id=90

HTH

[Bob Phillips]

Hey all,

I am wondering if there is any way to set more than the limited 3 conditional formats for any given cell. Or better yet is there any way of setting it for all workbooks. Thank you in advance for your help.

Thanx Scott

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

[infinity]

Thanx xld,

I downloaded the add in and installed it to the workbook that I want. All the options that are available do nothing. The option to "launch CF+" brings up a warning that reads "Current workbook/file has to be activated. Should CFPlus add the required event handlers and worksheets?" If I select "No" nothing happens, if I select "Yes" it switches worksheets and gives me an error that reads "Error while processing the workbook!" Do you have any suggestions? Thank you for your help.

Thanx Scott

[Bob Phillips]

Thanx xld,

I downloaded the add in and installed it to the workbook that I want. All the options that are available do nothing. The option to "launch CF+" brings up a warning that reads "Current workbook/file has to be activated. Should CFPlus add the required event handlers and worksheets?" If I select "No" nothing happens, if I select "Yes" it switches worksheets and gives me an error that reads "Error while processing the workbook!" Do you have any suggestions? Thank you for your help.

Thanx Scott

Post the workbook Scott, and I will take a look.