Q:

Conditional formatting not displaying cell highlights on coworkers computer

My boss has a spreadsheet that uses macros and conditional formatting to rearrange data and whatnot; he is running at least Office 2010. When my coworker opens it, however, it does not show cell fill colors; he is running 2007. It shows up on mine and I am also running 2010.
I am pretty Excel savy but this has me stumped.

A:

In Excel 2007, if your coworker wants the conditional formatting to work from another sheet, he is going to need to create a named range. Follow this link and scroll down a little to the "Conditional Formatting Workaround for Earlier Versions" section:
http://blog.contextures.com/archives/2010/09/03/conditional-formatting-from-different-sheet/

