Jmker
New member
- Joined
- Sep 8, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2016
I am trying to make column I update with current date when the comment in column H changes
Make comment and date fill turn yellow when date is 7 days old
Make comment and date fill turn red when date is 14 days old
Spreadsheet is populated with old sample data.
Prefer to not use VBA but ok if not possible.
Make comment and date fill turn yellow when date is 7 days old
Make comment and date fill turn red when date is 14 days old
Spreadsheet is populated with old sample data.
Prefer to not use VBA but ok if not possible.