I'm running Excel 2002 under Windows 2000 Professional on a Dell Inspiron 4100. I have a workbook that I created and now share with other users (Sharing is turned on). Now I want to add some conditional formatting but that option is grayed out when I click Format. I can turn off sharing and make the change but then I lose all the change history and I don't want to do that. Is there a way to add conditional formatting to some of the cells without losing the change history?
Thanks for any help you can give.