WedgeExcel
New Member
- Joined
- Jan 8, 2021
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi there! I'm working on a schedule, date being on the X-axis and the relevant parties on the Y-axis. Each row uses conditional formatting to colour it when there is an input in the cell. Often, an activity drags out over several days and to fit the name of the activity and for the sake of aesthetics, we merge cells. I've made a macro that reformats the scedule's borders, but I'm having a hard time figuring out how to automatically re-apply the conditional formating the sheet uses to the cells appear after unmerging a cell.
Tldr: how can I get Excel to automatically reapply conditional formating to the cells that appear after unmerging cells?
Thanks in advance!
Tldr: how can I get Excel to automatically reapply conditional formating to the cells that appear after unmerging cells?
Thanks in advance!