Conditional Formatting option not available

[Jorge E. Jaramillo]

I have a spreadsheet that has been in use for several years and has plenty of
formulas and information. Trying to improve this sheet I came up with the
idea of coloring some cells according to some criteria, so that the users
easily distinguish special conditions of some values.

The problem is that when I tried to apply the conditional formatting to
those cells, the option Conditional Formatting is greyed out in the Format
menu.

Any ideas on how to fix this?

Thanks in advance

Jorge Jaramillo

 

[Stefi]

Maybe the sheet is protected?
Regards,
Stefi

„Jorge E. Jaramillo†ezt írta:

 

[Jim Thomlinson]

Either the sheet is protected or the workbook is shared. Both of those lock
out CF.

 

[Jorge E. Jaramillo]

The workbook is shared and it needs to be so. What can i do to change those
formats and then go back to the normal conditions?

 

[Gord Dibben]

Unshare, apply your formatting, reshare.


Gord Dibben MS Excel MVP

 

[Jorge E. Jaramillo]

Yes it is kind of obvious. Thanks.

Jorge E Jaramillo

 

[Gord Dibben]

Wish there were an easier method.

Gord

Yes it is kind of obvious. Thanks.

Jorge E Jaramillo