Conditional Formatting

D

daninky

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?
 
D

daninky

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.
 
C

Carim

Hi,

Use VBA for following instruction :

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

HTH
Carim
 
G

Gord Dibben

How about Tools>Share Workbook?

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


Gord Dibben MS Excel MVP
 
Top