PasteLink.jpg

<div>
Both good answers that dealt with my query :-)
</div>


Both good answers that dealt with my query :-)

<div>
<div class="content wysiwyg-content">
hi <br />
Just wondering if it's possible to copy/link conditional formatting to another file. e.g. if a cell &nbsp;is triggered to go red in File X....and this cell is pulled into another file, can I copy the conditional formatting with it or does it also have to be set up in the destination file? Thanks.
</div>
</div>


hi 
Just wondering if it's possible to copy/link conditional formatting to another file. e.g. if a cell  is triggered to go red in File X....and this cell is pulled into another file, can I copy the conditional formatting with it or does it also have to be set up in the destination file? Thanks.

Copy Excel 2007 conditional formatting to another file?

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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