robgoldstein
Board Regular
- Joined
- Oct 26, 2013
- Messages
- 165
- Office Version
- 2019
- Platform
- Windows
Hey All,
I am trying to format some columns with a fill colour if a merged cell (E2:O2) matches a date in a list on another sheet named "Dates Mall is Closed" in column A. That merged cell contains a formula based on cell B1. The Formula for Monday is B1+0, but I then repeat this formula for other meged cells with increasing number. I will repeat the formatting for those other groups of columns.
Can any of you help with a way to make this work?
Thanks.
I am trying to format some columns with a fill colour if a merged cell (E2:O2) matches a date in a list on another sheet named "Dates Mall is Closed" in column A. That merged cell contains a formula based on cell B1. The Formula for Monday is B1+0, but I then repeat this formula for other meged cells with increasing number. I will repeat the formatting for those other groups of columns.
Can any of you help with a way to make this work?
Thanks.