ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 237
- Office Version
- 2021
- Platform
- Windows
Hi All,
I am endeavouring to highlight the current date and the next 7 days, the following formula being used in Conditional Formatting [=AND($A2-TODAY()>=0, $A2-TODAY()<=7) A2 Being the first of the month] this works when the dates are listed in a column but not in a row and I have searched the net to find a solution to no avail.
Any assistance would be greatly appreciated.
Cheers,
Dave.
Column
Row
I am endeavouring to highlight the current date and the next 7 days, the following formula being used in Conditional Formatting [=AND($A2-TODAY()>=0, $A2-TODAY()<=7) A2 Being the first of the month] this works when the dates are listed in a column but not in a row and I have searched the net to find a solution to no avail.
Any assistance would be greatly appreciated.
Cheers,
Dave.
Column
date cf.xlsx | |||
---|---|---|---|
A | |||
2 | Sat 01-Oct-22 | ||
3 | Sun 02-Oct-22 | ||
4 | Mon 03-Oct-22 | ||
5 | Tue 04-Oct-22 | ||
6 | Wed 05-Oct-22 | ||
7 | Thu 06-Oct-22 | ||
8 | Fri 07-Oct-22 | ||
9 | Sat 08-Oct-22 | ||
10 | Sun 09-Oct-22 | ||
11 | Mon 10-Oct-22 | ||
12 | Tue 11-Oct-22 | ||
13 | Wed 12-Oct-22 | ||
14 | Thu 13-Oct-22 | ||
15 | Fri 14-Oct-22 | ||
Column |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2:A15 | Expression | =AND($A2-TODAY()>=0, $A2-TODAY()<=7) | text | NO |
Row
date cf.xlsx | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
2 | Sat 01-Oct-22 | Sun 02-Oct-22 | Mon 03-Oct-22 | Tue 04-Oct-22 | Wed 05-Oct-22 | Thu 06-Oct-22 | Fri 07-Oct-22 | Sat 08-Oct-22 | Sun 09-Oct-22 | Mon 10-Oct-22 | Tue 11-Oct-22 | Wed 12-Oct-22 | Thu 13-Oct-22 | Fri 14-Oct-22 | Sat 15-Oct-22 | Conditional Formatting =AND($A2-TODAY()>=0, $A2-TODAY()<=7) | ||
Row |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A2:O2 | Expression | =AND($A2-TODAY()>=0, $A2-TODAY()<=7) | text | NO |