ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/246162-conditional-formatting.html)

grizzly6969

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

Gord Dibben

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



grizzly6969

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


Gord Dibben

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



grizzly6969

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


.



All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com