• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Excel 2007 strips out 2010 conditional Formatting?

I have a file in excel 2010 with a lot of conditional formatting but when I send this to a colleague who only has 2007 he does not see any of the conditional formatting. Is anyone aware of this happening and is there a fix? I have searched for the last hour and cant see anything on this.
0
bryanscott53
Asked:
bryanscott53
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
What kind of CF is it?
0
 
bryanscott53Author Commented:
Hi rorya, I attach an image as I did not know there were different types sorry. Screen Shot of Conditional Formatting Window
0
 
Rory ArchibaldCommented:
Ah - that explains it. 2010 allows you to refer directly to another worksheet in the CF formula, but prior versions do not. You have to use named ranges to bypass that limitation.
0
 
bryanscott53Author Commented:
a bit more work for me then but at least I now know! many thanks for your help thias has saved me a lot of head scratching!!
0
 
Rory ArchibaldCommented:
Glad to help. FYI, it's the same story with data validation.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now