Ah right, sorry hadn't taken in to account that you might want to do this across workbooks.
Perhaps you could record a macro for the conditional formatting and tweak it to your liking? (e.g. to work for different ranges, remove horrible ".Select" statements, etc)




Reply With Quote

Bookmarks