| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting option not available
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
Maybe the sheet is protected?
Regards, Stefi €˛Jorge E. Jaramillo€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
Either the sheet is protected or the workbook is shared. Both of those lock
out CF. -- HTH... Jim Thomlinson "Jorge E. Jaramillo" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
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? "Jim Thomlinson" wrote: Either the sheet is protected or the workbook is shared. Both of those lock out CF. -- HTH... Jim Thomlinson "Jorge E. Jaramillo" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
Unshare, apply your formatting, reshare.
Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 07:08:02 -0700, Jorge E. Jaramillo wrote: 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? "Jim Thomlinson" wrote: Either the sheet is protected or the workbook is shared. Both of those lock out CF. -- HTH... Jim Thomlinson "Jorge E. Jaramillo" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
Yes it is kind of obvious. Thanks.
Jorge E Jaramillo "Gord Dibben" wrote: Unshare, apply your formatting, reshare. Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 07:08:02 -0700, Jorge E. Jaramillo wrote: 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? "Jim Thomlinson" wrote: Either the sheet is protected or the workbook is shared. Both of those lock out CF. -- HTH... Jim Thomlinson "Jorge E. Jaramillo" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting option not available
Wish there were an easier method.
Gord On Fri, 25 Sep 2009 06:26:02 -0700, Jorge E. Jaramillo wrote: Yes it is kind of obvious. Thanks. Jorge E Jaramillo "Gord Dibben" wrote: Unshare, apply your formatting, reshare. Gord Dibben MS Excel MVP On Thu, 24 Sep 2009 07:08:02 -0700, Jorge E. Jaramillo wrote: 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? "Jim Thomlinson" wrote: Either the sheet is protected or the workbook is shared. Both of those lock out CF. -- HTH... Jim Thomlinson "Jorge E. Jaramillo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill down option in conditional formatting? | Excel Worksheet Functions | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Conditional Formatting option "Grayed Out" | Excel Worksheet Functions | |||
| Flashing cell for conditional formatting as an option | Excel Worksheet Functions | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Linear Mode
