Conditional Formatting
 

Hi, does anyone have a resource that says what could cause conditional
formatting to NOT be an option? Basically, I'm trying to format this sheet,
and I can't select conditional formatting.

Conditional Formatting
 

Two reasons I can think of.

1. The sheet is protected.

2. The workbook is shared.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 12:21:00 -0800, ktoth04
wrote:

Hi, does anyone have a resource that says what could cause conditional
formatting to NOT be an option? Basically, I'm trying to format this sheet,
and I can't select conditional formatting.

Conditional Formatting
 

Can you tell me how to verify whether these are true? I'm relatively certain
its not protected, as unprotect is not an option - how can I verify whether
or not it is shared? And how can I unshare it so I can edit it?

"Gord Dibben" wrote:

Two reasons I can think of.

1. The sheet is protected.

2. The workbook is shared.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 12:21:00 -0800, ktoth04
wrote:

Hi, does anyone have a resource that says what could cause conditional
formatting to NOT be an option? Basically, I'm trying to format this sheet,
and I can't select conditional formatting.

Conditional Formatting
 

ToolsShare Workbook.

If shared, the optionbox "Allow changes by more than one user etc." will have a
check in it and the name(s) of who has it open currently.

To unshare, disable the "Allow" option and save the workbook.

Actually Excel will ask you to save.


Gord

On Wed, 27 Feb 2008 13:38:02 -0800, ktoth04
wrote:

Can you tell me how to verify whether these are true? I'm relatively certain
its not protected, as unprotect is not an option - how can I verify whether
or not it is shared? And how can I unshare it so I can edit it?

"Gord Dibben" wrote:

Two reasons I can think of.

1. The sheet is protected.

2. The workbook is shared.


Gord Dibben MS Excel MVP

On Wed, 27 Feb 2008 12:21:00 -0800, ktoth04
wrote:

Hi, does anyone have a resource that says what could cause conditional
formatting to NOT be an option? Basically, I'm trying to format this sheet,
and I can't select conditional formatting.