| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I have an excel spredsheet (2000 )and the conditional formatting is ghosted
out why is this and can I make it work. I want to have a cell change color when the letter "V" is in the cell -- grizz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
If the worksheet is protected, unprotect it.
If the workbook is shared, unshare it. Gord Dibben MS Excel MVP On Wed, 21 Oct 2009 15:40:12 -0700, grizzly6969 wrote: I have an excel spredsheet (2000 )and the conditional formatting is ghosted out why is this and can I make it work. I want to have a cell change color when the letter "V" is in the cell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
This is a shared work book and I do have full control -- also the protect
work book and protect work sheet is ghosted out -- grizz "grizzly6969" wrote: I have an excel spredsheet (2000 )and the conditional formatting is ghosted out why is this and can I make it work. I want to have a cell change color when the letter "V" is in the cell -- grizz |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Which is normal when a workbook is shared.
Gord On Wed, 21 Oct 2009 15:53:01 -0700, grizzly6969 wrote: This is a shared work book and I do have full control -- also the protect work book and protect work sheet is ghosted out |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Thank you for your help
-- grizz "Gord Dibben" wrote: If the worksheet is protected, unprotect it. If the workbook is shared, unshare it. Gord Dibben MS Excel MVP On Wed, 21 Oct 2009 15:40:12 -0700, grizzly6969 wrote: I have an excel spredsheet (2000 )and the conditional formatting is ghosted out why is this and can I make it work. I want to have a cell change color when the letter "V" is in the cell . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
