LinkBack URL
About LinkBacks
Conditional formatting fill colors obtained as a result I just want to copy the color is there a way to do this?
Conditional formatting fill colors obtained as a result I just want to copy the color is there a way to do this?
I don't understand your question. If you want to know what colour is used in the conditional formatting, then go to the rule itself and find out what fill colour was used.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Welcome to the Forum,
Dave Peterson has provided some code https://groups.google.com/forum/#!to...sc/3kbkrAHUjIs please check it.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are conditional formatting rules as a result of the fill color. I want to copy the fill color. I just want to copy fill colors. I want to copy the rules are not just colors.
Just copy the data (that has been conditionally formatted) and paste it in MS-Word document. Now, recopy the same data from MS-Word and paste it in MS-Excel.
There is no other way to do this as per my knowledge however you can check link above mentioned and get VBA code for the same.
Hope it will help you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks