I have an Excel 2007 spreadhseet with several rows highlighted in different
colors for different reasons. I saved it down to 2003; however, when someone
else opens the file in 2003, all the color formatting is gone.

Since our office is slowly transitioning from 2003 to 2007, this could
potentially cause problems for 6 months or more. Is this something we will
have to work around or is there a fix?

Thank you! and thanks for the time you put into answering these questions.