Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook
 

Hi,

I have a conditional format in my workbook, which just basically says if value of a field in different worksheet = 1, then set font and background color to orange. It works perfect on my machine.

When I email to anyone, the conditional formatting disappears. I even tried saving the workbook to a shared drive and then opening from there myself, and it disappeared again.

At first I thought it was because I'm using 2010 and others on my team have 2007....however the shared drive test seems to mean that logic doesn't make sense. Is this an Excel Bug? Has anyone experienced this before, and is there a way around it?

Thanks for any help!!