Conditional Formatting
 

No matter what I try, I cannot get the Conditional Formatting function to
work on any cell in my workbook. Any ideas what could be causing this?

Conditional Formatting
 

Hi,

Do you have an example of formula which is not working ...?

Carim

Conditional Formatting
 

Can't even get to that point. I click on "Format", and one of the options to
use is Conditional Formatting, but the button is not active.

"Carim" wrote:

Hi,

Do you have an example of formula which is not working ...?

Carim

Conditional Formatting
 

Tools Protection UnprotectSheet..........

Vaya con Dios,
Chuck, CABGx3



"daninky" wrote:

Can't even get to that point. I click on "Format", and one of the options to
use is Conditional Formatting, but the button is not active.

"Carim" wrote:

Hi,

Do you have an example of formula which is not working ...?

Carim

Conditional Formatting
 

Hi,

Use VBA for following instruction :

Application.CommandBars("Format").Controls("Condit ional
Formatting").Enabled = True

HTH
Carim

Conditional Formatting
 

Thanks, but no good... doesn't give me the Unprotect Sheet option...

"CLR" wrote:

Tools Protection UnprotectSheet..........

Vaya con Dios,
Chuck, CABGx3



"daninky" wrote:

Can't even get to that point. I click on "Format", and one of the options to
use is Conditional Formatting, but the button is not active.

"Carim" wrote:

Hi,

Do you have an example of formula which is not working ...?

Carim

Conditional Formatting
 

How about ToolsShare Workbook?

De-select the "allow changes etc." option.


Gord Dibben MS Excel MVP


On Fri, 13 Oct 2006 09:59:01 -0700, daninky
wrote:

Thanks, but no good... doesn't give me the Unprotect Sheet option...

"CLR" wrote:

Tools Protection UnprotectSheet..........

Vaya con Dios,
Chuck, CABGx3



"daninky" wrote:

Can't even get to that point. I click on "Format", and one of the options to
use is Conditional Formatting, but the button is not active.

"Carim" wrote:

Hi,

Do you have an example of formula which is not working ...?

Carim