SelinaR
Board Regular
- Joined
- Feb 2, 2012
- Messages
- 65
- Office Version
- 2021
- Platform
- Windows
- Mobile
- Web
Hi there
I would like to put in cond. formatting on date ranges that will pick up from TODAY() - I have tried various options - pre set on excel and my own formula
of greater than, or equal to such as =TODAY() & =NOW() & DATEDIF, etc, but seem to be getting blank zones within the range and my formula's specific to today vs. 28 days from now . Please help - I am looking for more of a range that will format rather than an actual date to highlight
Example of rules (all feeding off of today &/or an input date):
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks so much for your help in advance.
Selina
I would like to put in cond. formatting on date ranges that will pick up from TODAY() - I have tried various options - pre set on excel and my own formula
of greater than, or equal to such as =TODAY() & =NOW() & DATEDIF, etc, but seem to be getting blank zones within the range and my formula's specific to today vs. 28 days from now . Please help - I am looking for more of a range that will format rather than an actual date to highlight
Example of rules (all feeding off of today &/or an input date):
1st | Within 28 Days (current) |
2nd | After 28 days (going to lapse) |
3rd | >29 days & up to 3 months |
4th | over 3 Months |
5th | >6 Months |
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks so much for your help in advance.
Selina