Highlight cell based on day of the month

[lorenambrose]

Hey all,

I have a worksheet with a column called day. It is 31 rows long. The cells are formatted as TEXT "01" through "31".

I want to conditionally format the cell based on the day of the month. If it is the 15th day of the month, then highlight the cell with "15" in it.

I thought it would be easy enough, but since this is not actually a calendar and is divorced from the month and year, it is proving to be very challenging.

Thanks,
Loren

 

[kevin9999]

test.xlsm
	A
1	DAY
2	01
3	02
4	03
5	04
6	05
7	06
8	07
9	08
10	09
11	10
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22	21
23	22
24	23
25	24
26	25
27	26
28	27
29	28
30	29
31	30
32	31
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A32	Expression	=A2=TEXT(DAY(TODAY()),"dd")	text	NO

 

[lorenambrose]

test.xlsm
	A
1	DAY
2	01
3	02
4	03
5	04
6	05
7	06
8	07
9	08
10	09
11	10
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
21	20
22	21
23	22
24	23
25	24
26	25
27	26
28	27
29	28
30	29
31	30
32	31
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A32	Expression	=A2=TEXT(DAY(TODAY()),"dd")	text	NO

I see where you are going, but it is not working.

Maybe a bit of detail:

The day column is "B"

mos important the column is actually 62 rows as every 2 cells are merged making 31 cells

B3:B4 = 01
B5:B6 = 02.......

 

[kevin9999]

Just a tip, avoid merged cells like the plague.

test.xlsm
	A	B	C
1		DAY
2
3		01
4
5		02
6
7		03
8
9		04
10
11		05
12
13		06
14
15		07
16
17		08
18
19		09
20
21		10
22
23		11
24
25		12
26
27		13
28
29		14
30
31		15
32
33		16
34
35		17
36
37		18
38
39		19
40
41		20
42
43		21
44
45		22
46
47		23
48
49		24
50
51		25
52
53		26
54
55		27
56
57		28
58
59		29
60
61		30
62
63		31
64
65
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B64	Expression	=B3=TEXT(DAY(TODAY()),"dd")	text	NO

 

[lorenambrose]

Here is exactly what I am working with.....

 

[lorenambrose]

Just a tip, avoid merged cells like the plague.

test.xlsm
	A	B	C
1		DAY
2
3		01
4
5		02
6
7		03
8
9		04
10
11		05
12
13		06
14
15		07
16
17		08
18
19		09
20
21		10
22
23		11
24
25		12
26
27		13
28
29		14
30
31		15
32
33		16
34
35		17
36
37		18
38
39		19
40
41		20
42
43		21
44
45		22
46
47		23
48
49		24
50
51		25
52
53		26
54
55		27
56
57		28
58
59		29
60
61		30
62
63		31
64
65
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B64	Expression	=B3=TEXT(DAY(TODAY()),"dd")	text	NO

It is just not working. Am I entering it wrong? Do I highlight cells B3 through B64 and enter the formula that way?

 

[kevin9999]

You seem to have done everything exactly as I did. If you could provide a sample of your sheet using the XL2BB add in it would be a great help.

test.xlsm
	A	B
1
2		DAY
3		01
4
5		02
6
7		03
8
9		04
10
11		05
12
13		06
14
15		07
16
17		08
18
19		09
20
21		10
22
23		11
24
25		12
26
27		13
28
29		14
30
31		15
32
33		16
34
35		17
36
37		18
38
39		19
40
41		20
42
43		21
44
45		22
46
47		23
48
49		24
50
51		25
52
53		26
54
55		27
56
57		28
58
59		29
60
61		30
62
63		31
64
65
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B64	Expression	=B3=TEXT(DAY(TODAY()),"dd")	text	NO

 

[lorenambrose]

You seem to have done everything exactly as I did. If you could provide a sample of your sheet using the XL2BB add in it would be a great help.

test.xlsm
	A	B
1
2		DAY
3		01
4
5		02
6
7		03
8
9		04
10
11		05
12
13		06
14
15		07
16
17		08
18
19		09
20
21		10
22
23		11
24
25		12
26
27		13
28
29		14
30
31		15
32
33		16
34
35		17
36
37		18
38
39		19
40
41		20
42
43		21
44
45		22
46
47		23
48
49		24
50
51		25
52
53		26
54
55		27
56
57		28
58
59		29
60
61		30
62
63		31
64
65
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B64	Expression	=B3=TEXT(DAY(TODAY()),"dd")	text	NO

It is going to take some doing regarding that plugin. This is a work computer.

 

[kevin9999]

It is going to take some doing regarding that plugin. This is a work computer.

Unfortunately, because I can't replicate the problem you're having, I don't think there's much more I can do.

 

[lorenambrose]

Something off with the entire column. I deleted the column and recreated it and now it is working.