Is it possible to copy Conditional Formatting settings in one worksheet to others in the same workbook?
Is it possible to copy Conditional Formatting settings in one worksheet to others in the same workbook?
Short answer: no.
If you copy and paste CF formatted cells from one sheet to another, a rule will be set up - does this help?
I am not sure if it can be done with VBA - should I move the thread for you to that section?
Last edited by AliGW; 07-24-2019 at 04:51 AM.
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.
I would appreciate it. Thank you.
I have just updated my response above to say that if you copy and paste CF formatted cells, then a rule is set up - does that help? If not, I'll move the thread.
I'll give that a go real quick.
OK - I'm moving you.
Not quite sure what you mean - doesn't work for your requirements? I mean, it DOES work in terms of the copy paste ...
I copied the sheet with the CF settings on over to another sheet, but none of the settings seemed to work at all, even though some of them did show up. I ended up using format painter though and it copied the CF settings over just fine.
Thanks for letting us know.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks