<div>
Hi rorya, I attach an image as I did not know there were different types sorry. <a href="https://filedb.experts-exchange.com/incoming/2011/09_w37/496229/Capture.PNG" target="_blank" title="Screen Shot of Conditional Formatting Window (64 KB)"><img alt="Screen Shot of Conditional Formatting Window" class="file-block lazyload" style="max-width: 626px;" data-src="https://filedb.experts-exchange.com/incoming/2011/09_w37/496229/Capture.PNG" /></a>
</div>


Hi rorya, I attach an image as I did not know there were different types sorry. Screen Shot of Conditional Formatting Windowhttps://filedb.experts-exchange.com/incoming/2011/09_w37/496229/Capture.PNG

Screen Shot of Conditional Formatting Window

Capture.PNG

<div>
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!!
</div>


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!!

<div>
Glad to help. FYI, it's the same story with data validation.
</div>


Glad to help. FYI, it's the same story with data validation.

<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Excel 2007 strips out 2010 conditional Formatting?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.