Scottie4
New Member
- Joined
- Oct 5, 2022
- Messages
- 12
- Office Version
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
I currently have a conditional format of =E2:E25=TODAY(), which highlights the cell when the date arrives and disappears when it’s not that date anymore. is there anyway I can keep the cell highlighted once it has passed the date that made the cell highlight?