conditional formatting

[grizzly6969]

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

 

[Gord Dibben]

If the worksheet is protected, unprotect it.

If the workbook is shared, unshare it.


Gord Dibben MS Excel MVP

 

[grizzly6969]

This is a shared work book and I do have full control -- also the protect
work book and protect work sheet is ghosted out

 

[Gord Dibben]

Which is normal when a workbook is shared.


Gord

 

[grizzly6969]

Thank you for your help
--
grizz

If the worksheet is protected, unprotect it.

If the workbook is shared, unshare it.


Gord Dibben MS Excel MVP



.