Easy enough:
Book1 |
---|
|
---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL |
---|
1 | 2028 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
2 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
6 | | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M |
---|
7 | January | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
---|
8 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
9 | February | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | | | | | | |
---|
10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
11 | March | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | |
---|
12 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
13 | April | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | |
---|
14 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
15 | May | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | | |
---|
16 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
17 | June | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | | | |
---|
18 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
19 | July | | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
---|
20 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
21 | August | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | |
---|
22 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
23 | September | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | | |
---|
24 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
25 | October | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | | | | | | |
---|
26 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
27 | November | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | | | | |
---|
28 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
29 | December | | | | | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | |
---|
30 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
---|
|
---|
I thought the 2nd row might be for something else. So you might want to delete the formulas from the even rows (B8, B10, etc.) so that would leave them empty for something else.
Also, this Conditional Formatting formula will just highlight anything that isn't a blank in the B7:AL30 range. So for a starting grid like this, only the dates will be highlighted. But if you add something in the next row, it will be highlighted too. Here are a couple variants if you prefer:
will only highlight the top (date) row.
will always highlight both the date row and the row below it.
If you want the 2nd row to be a different color, you'd need another CF rule.