Struggled with the best title for this post... my apologies...
I have two tabs. Tab "A" contains data that is pasted during a macro. Tab "B" uses INDEX and MATCH formulae to return values from "A" because the row and columns vary week to week.
Here's the challenge.... The data in the cells in tab "A" will be either 'no fill', or green, or red. I would like for the corresponding linked-cell in "B" to also have the color of it's twin on "A"...
Is that possible?
Thank you for any direction!
Unless you have a logical rule behind the coloring, i.e. green cells are numbers < 100, there is no way to link the cell colors using formulas. You would have to resort back to VBA to do that. If there is a logical rule behind the colors, you can use conditional formatting.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Chemist... I'll post this in VBA and cross fingers...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks