One-button formatting of a cell, in different workbooks, but personal macros aren’t working for me.
I am trying to sort a very particular problem. I want to be able to tap one button (which will be assigned to a keyboard macro, so could be a short string of keypresses) that formats a cell in a particular way.
The use case is running a daily timetable to send out to teaching staff, with a different colour scheme in those cells representing lessons which are different. None of the default “cell styles” really work, as they need to stand out against the timetable colour scheme to be instantly apparent.
I have been using format painter, which is fine, but I have to leave a copy of the “changed” format at the side when I am working on the sheet. I’d really like a one-button solution. I tried saving macros in a couple of ways, but even when I got a macro perfectly working, running it clears the undo function, which when I am solving a complex timetable puzzle is not ideal…
Am I missing a clever way of achieving this?