mattstan2012
New Member
- Joined
- May 23, 2024
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hi - I have a rota spreadsheete luike this. I want to highlight today's date (i.e 14 Feb - the cell actually contains the full date but is formatted to just show "dd") and the 4 cells BELOW it in the same column. Any ideas? I've had loads of suggestions from ChatGPT, but none have worked and mainly end up highlighting the cells to the LEFT in the same ROW, not the ones BELOW in the same COLUMN