Conditional Formatting to highlight current month based on date range

[ExcelNewbie2020]

Experts, Is it possible to highlight the current month based on the date? See below photo.
Since we are now on the month of January, i would like to have a highlight from the 1st to last day of January. The same will happen on the succeeding months. Thank you very much..

 

[maabadi]

Sell total Range, Go to Conditional formatting, Manage Rule, New Rule , Select "Use a formula ..." and Input this formula

INDIRECT(ADDRESS(1,COLUMN()+1-A$2,4))=TEXT(MONTH(TODAY()),"mmmm")

Then Add your Fill color and Apply.

 

[ExcelNewbie2020]

Sell total Range, Go to Conditional formatting, Manage Rule, New Rule , Select "Use a formula ..." and Input this formula

INDIRECT(ADDRESS(1,COLUMN()+1-A$2,4))=TEXT(MONTH(TODAY()),"mmmm")

Then Add your Fill color and Apply.

Thank you so much.. It did not work.. when i check the formula it results to #VALUE! might there is single digit missing..

 

[alz]

It look like Your Data is mix with and Date and text even to your pointed as Formated by date "DD"
I assume A2:AE2 have some text and other are Date
And Also Jaunuary is input at A1 and February is at Af1 ?

 

[ExcelNewbie2020]

It look like Your Data is mix with and Date and text even to your pointed as Formated by date "DD"
I assume A2:AE2 have some text and other are Date
And Also Jaunuary is input at A1 and February is at Af1 ?

Thanks, its not text its a formula like =date+1 and =+date+1 that I dragged. But I corrected it now all to =date+1. Please see table

sample.xlsx
	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	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG
1	JANUARY																															FEBRUARY
2	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Sheet6

Cell Formulas
Range	Formula
B2:BG2	B2	=A2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:BG24	Expression	=INDIRECT(ADDRESS(1,COLUMN()+1-A$2,4))=TEXT(MONTH(TODAY()),"mmmm")	text	NO

 

[alz]

Use this !
=TEXT(A$2,"mm")=TEXT(TODAY(),"mm")

 

[ExcelNewbie2020]

Use this !
=TEXT(A$2,"mm")=TEXT(TODAY(),"mm")

Thanks Man, It works like a charm...