Losing conditional formatting upon saving

**tjl1974** · 03-23-2009, 11:17 AM

Hi,
I have a very weird issue with a particular worksheet, which we are a few users sharing from a server on a read-only basis. We are using conditional formulas to highlight positive or negative values (green, red, etc). However, this sheet will for some reason when opening on my computer lose all conditional formatting, while my colleagues will have all the formatting kept. When I look under "manage rules" in conditional formatting, there are none. I have checked that we all run the SP1 version of 2007 excel, but I cant figure out what is the problem. Does anyone have an explanation on this very weird issue?
Thanks,
Thomas

**Richard Buttrey** · 03-23-2009, 11:29 AM

Hi,

Do you still lose all the formatting when you are the first and only one to open the workbook?

Rgds

**tjl1974** · 03-23-2009, 11:33 AM

Yes.

I am usually not the one editing and saving the sheet. However, my problem is regardless of anyone having the sheet open already or I am the first one opening the sheet. Also, regardless of whether I open the sheet in a editable version and not read-only.

**Bruckner** · 09-26-2012, 04:41 PM

Originally Posted by tjl1974

Hi,
I have a very weird issue with a particular worksheet, which we are a few users sharing from a server on a read-only basis.

I know this is an old thread but I had the same issue (ex2007). Different users are updating few files with multiple cells having conditional formatting styles. I solved the problem by using the "open & repair" option.