PDA

View Full Version : more than 3 conditional formats?



infinity
11-01-2005, 01:23 PM
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
11-01-2005, 01:37 PM
Try this KB entry:

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

HTH

Bob Phillips
11-01-2005, 02:30 PM
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.CFPlus.Download.html

infinity
11-03-2005, 01:02 AM
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
11-03-2005, 03:26 AM
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.