Conditional Formatting

[Guest]

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?

 

[Carim]

Hi,

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

Carim

 

[Guest]

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.

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

 

[Carim]

Hi,

Use VBA for following instruction :

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

HTH
Carim

 

[Guest]

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

 

[Gord Dibben]

How about Tools>Share Workbook?

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


Gord Dibben MS Excel MVP