I have a master column of data, and 10 sub columns of the same data. Each sub column has a title fill color. I want the Master column to fill with the color of sub column of it's duplicate. For instance: if C2 = H7, fill C2 with H1 title fill color. Is this possible?
No without VBA.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Is there a site a can find a script?Originally Posted by KOKOSEK
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
What I would like, is if the data in columns E thru O matches the data in column C I want the backfill color in the respective column to to fill in column C. This will be a working document that will be updated regularly.
Try like this:
Please Login or Register to view this content.
That is perfect! Works great, thank you!
Moved to VBA sub-forum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks