bobjglover@gmail.com
New member
- Joined
- Aug 3, 2015
- Messages
- 57
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 1901
Hello Guru's,
I need a formula that will change the color of a cell based on a date and not change once the date has moved on. Conditional formatting will do this but limited to one month out. I need it to make a color change (red) based on 1 month and (yellow) three months out. See attached for what I would like it to look like.
Kind Regards - Bob
I need a formula that will change the color of a cell based on a date and not change once the date has moved on. Conditional formatting will do this but limited to one month out. I need it to make a color change (red) based on 1 month and (yellow) three months out. See attached for what I would like it to look like.
Kind Regards - Bob