Thread
:
Why is conditional formatting disabled(!)?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
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.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom