Conditional Format is grayed out

  • Thread starter Thread starter resolute
  • Start date Start date
R

resolute

Excell 2002 on a XP Pro.

How do I activate(?) the grayed out "Conditional Forma" on the Forma
menu.

TIA

Bo
 
Tried that. thanks for the tip, started me looking in the righ
direction, but haven
t solved the problem.

The worksheet is shared. I searched help to "unprotect" a worksheet
Tools/protect . On both computers.

Also Format/cells/protection, and unchecked that (on both machines
the other is a 98se, with Excell 2000 on it. I wonder if there is
conflict between, Excell 2000 and 2002?. Anyway, I continue to have t
de select Format/cells/protection
 
Still having problems with this, but this is what I have done since thi
morning. I've copied from one work book to another. In the new workboo
I have the ability to use Format/Conditional Format. The new work boo
is NOT shared. I can not delete the information from the old work boo
then replace it. This tells me either a problme exists with sharing th
original workbook, or something is inbedded on the original page. Hav
attempted to located formatting problems, but being new at this reall
do not understand if I have done the search correctly. Pontentia
exists to create two problems instead of just the one, of not havin
the ability to use conditional formating. ???

:confused
 
Your problem is that workbook is shared.
To unshare: Tools, share workbook ...,
uncheck allow changes by more than one user ...
--
 
Back
Top