Hi all!
I have an excel file where a table has conditional formatting. Lets say it's in array Q2:V1000. Formatting for each row depends on value in columns X, Y and Z.
I need to use this file daily with new data each day.
How to copy data from this file to new document so that formatting stays the same (conditionally formated bold and filled cells), but it is 'normal formatting', because those X, Y, Z column values will change once I import next days data?
Hi
If I understood your problem well, in order to keep the conditional formatting valid, you must include the X, Y, Z columns in the import.
Regards
Just found the original, this is a duplicate of https://www.excelforum.com/excel-for...g-is-used.html
Robert, as per forum rules, only one thread per question / topic. Please do not start duplicates.
Jose, you should have noticed this, you replied to the original.
Last edited by jason.b75; 08-17-2018 at 06:51 AM.
Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
Thread Closed.
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks