 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2004Conditional Format is grayed out
Excell 2002 on a XP Pro. How do I activate(?) the grayed out "Conditional Forma" on the Forma menu. TIA Bo -- Message posted from http://www.ExcelForum.com Unprotect the sheet Bob Umlas Excel MVP > Excell 2002 on a XP Pro. > [quoted text clipped - 7 lines] > --- > Message posted from http://www.ExcelForum.com/ 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 -- Message posted from http://www.ExcelForum.com 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 -- Message posted from http://www.ExcelForum.com Your problem is that workbook is shared. To unshare: Tools, share workbook ..., uncheck allow changes by more than one user ...  Signature--- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Still having problems with this, but this is what I have done since this > morning. I've copied from one work book to another. In the new workbook [quoted text clipped - 11 lines] > --- > Message posted from http://www.ExcelForum.com/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.