Why is conditional formatting disabled(!)?
 

I'm having a "bad hair day" and the frustration level is high, so
forgive me if this is a "stupid" question.

I have a spreadsheet that have cells with conditional formatting. I
confirm that using Edit - Goto - Special - Conditional Format.

Yet when I select one of those cells -- or any cell without conditional
formatting -- and click on Format, the Condition Formatting option is
greyed out (disabled).

Why? That is, how might that have happened?

More importantly, how do I re-enable the ability to enable or change
Conditional Formatting?

I am using Office Excel 2003. I created the workbook, and it remains
on the computer where it originated. I do not recall setting any
special options for the workbook.

Why is conditional formatting disabled(!)?
 

Is your sheet protected (toolsprotectionunprotect sheet)?

Regards,

Peo Sjoblom

wrote:
I'm having a "bad hair day" and the frustration level is high, so
forgive me if this is a "stupid" question.

I have a spreadsheet that have cells with conditional formatting. I
confirm that using Edit - Goto - Special - Conditional Format.

Yet when I select one of those cells -- or any cell without conditional
formatting -- and click on Format, the Condition Formatting option is
greyed out (disabled).

Why? That is, how might that have happened?

More importantly, how do I re-enable the ability to enable or change
Conditional Formatting?

I am using Office Excel 2003. I created the workbook, and it remains
on the computer where it originated. I do not recall setting any
special options for the workbook.

Why is conditional formatting disabled(!)?
 

Do you have the workbook shared? That would cause it...

" wrote:

I'm having a "bad hair day" and the frustration level is high, so
forgive me if this is a "stupid" question.

I have a spreadsheet that have cells with conditional formatting. I
confirm that using Edit - Goto - Special - Conditional Format.

Yet when I select one of those cells -- or any cell without conditional
formatting -- and click on Format, the Condition Formatting option is
greyed out (disabled).

Why? That is, how might that have happened?

More importantly, how do I re-enable the ability to enable or change
Conditional Formatting?

I am using Office Excel 2003. I created the workbook, and it remains
on the computer where it originated. I do not recall setting any
special options for the workbook.

Why is conditional formatting disabled(!)?
 

The sheet may be protected.

ToolsProtectionUnprotect sheet.

The workbook may be shared.

ToolsShare workbookUncheck "Allow users etc."


Gord Dibben MS Excel MVP


On 8 Jan 2007 11:55:55 -0800, wrote:

I'm having a "bad hair day" and the frustration level is high, so
forgive me if this is a "stupid" question.

I have a spreadsheet that have cells with conditional formatting. I
confirm that using Edit - Goto - Special - Conditional Format.

Yet when I select one of those cells -- or any cell without conditional
formatting -- and click on Format, the Condition Formatting option is
greyed out (disabled).

Why? That is, how might that have happened?

More importantly, how do I re-enable the ability to enable or change
Conditional Formatting?

I am using Office Excel 2003. I created the workbook, and it remains
on the computer where it originated. I do not recall setting any
special options for the workbook.

Why is conditional formatting disabled(!)?
 

I have the same problem and the workbook is shared. Is there any way of
keeping the workbook shared but enabling the conditional formatting?

"Sean Timmons" wrote:

Do you have the workbook shared? That would cause it...

" wrote:

I'm having a "bad hair day" and the frustration level is high, so
forgive me if this is a "stupid" question.

I have a spreadsheet that have cells with conditional formatting. I
confirm that using Edit - Goto - Special - Conditional Format.

Yet when I select one of those cells -- or any cell without conditional
formatting -- and click on Format, the Condition Formatting option is
greyed out (disabled).

Why? That is, how might that have happened?

More importantly, how do I re-enable the ability to enable or change
Conditional Formatting?

I am using Office Excel 2003. I created the workbook, and it remains
on the computer where it originated. I do not recall setting any
special options for the workbook.