Hello All,
I have a table that in my worksheet that is setup as an external connection. The remote file is an .xlsx worksheet sitting on a remote drive. When I setup the connection though, it loses cell fill color. It is proving to be a nightmare to try and add in a bunch of conditional formatting.
Surely to god there has to be a way for Excel to capture the cell color when refreshing the table on the local sheet!
Can anyone take a monday morning stab at this?
sorry, no there isnt, formatting is not data, and formulas work with data. Perhaps you could use VBA for thisSurely to god there has to be a way for Excel to capture the cell color when refreshing the table on the local sheet!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks