conditional format to change color

[JOEE1979]

I have a calendar that takes info from another sheet.
On the info sheet, column "B" changes to green if column "I" has a date.
I would like to replicate that on the calendar if possible and I'm so stuck.
The calendar is LIVE and changes every month.
If you can help me create the conditional format, I would appreciate it.

Thank you

Project tracker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1204	1-Mar-24	2446					1-Mar-24			31-Mar-24			YES	1
1205		8347					1-Mar-24			31-Mar-24			YES	2
1206		8362					1-Mar-24			31-Mar-24			YES	3
1207		8465					1-Mar-24			31-Mar-24			YES	4
1208		8518					1-Mar-24	1-Mar-24	1-Mar-24	31-Mar-24	SAME DAY			5
1209		0					1-Mar-24			31-Mar-24			YES	6
1210		0					1-Mar-24			31-Mar-24			YES	7
1211		0					1-Mar-24			31-Mar-24			YES	8
1212		0					1-Mar-24			31-Mar-24			YES	9
1213		0					1-Mar-24			31-Mar-24			YES	10
1214		0					1-Mar-24			31-Mar-24			YES	11
1215		0					1-Mar-24			31-Mar-24			YES	12
1216		0					1-Mar-24			31-Mar-24			YES	13
1217		0					1-Mar-24			31-Mar-24			YES	14
1218		0					1-Mar-24			31-Mar-24			YES	15
1219		0					1-Mar-24			31-Mar-24			YES	16
1220		0					1-Mar-24			31-Mar-24			YES	17
1221		0					1-Mar-24			31-Mar-24			YES	18
1222		0					1-Mar-24			31-Mar-24			YES	19
1223		0					1-Mar-24			31-Mar-24			YES	20
2024

Cell Formulas
Range	Formula
J1204:J1223	J1204	=G1204+30
K1204:K1223	K1204	=IF(IF(COUNTA(H1204,I1204)<>2,"",DAYS360(H1204,I1204,FALSE))=0,"SAME DAY",(IF(COUNTA(H1204,I1204)<>2,"",DAYS360(H1204,I1204,FALSE))))
B1204:B1223	B1204	=(B604)
G1204	G1204	=A1204
G1205	G1205	=A1204
G1206	G1206	=A1204
G1207	G1207	=A1204
G1208	G1208	=A1204
G1209	G1209	=A1204
G1210	G1210	=A1204
G1211	G1211	=A1204
G1212	G1212	=A1204
G1213	G1213	=A1204
G1214	G1214	=A1204
G1215	G1215	=A1204
G1216	G1216	=A1204
G1217	G1217	=A1204
G1218	G1218	=A1204
G1219	G1219	=A1204
G1220	G1220	=A1204
G1221	G1221	=A1204
G1222	G1222	=A1204
G1223	G1223	=A1204
M1204:M1223	M1204	=IF(AND($L$2>H1204,(ISBLANK(I1204))),"YES","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:B7323	Expression	=AND($L$2>=$G4, NOT(ISBLANK($I4)))	text	NO
B4:B7323	Expression	=AND($L$2>$G4, (ISBLANK($I4)))	text	NO
B4:B7323	Expression	=AND($L$2=$G4, (ISBLANK($I4)))	text	NO

Project tracker.xlsx
	C	D	E	F	G	H	I	J	K
2	March 2024
3	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
4	25	26	27	28	29	1	2
5	2464	2442	2461	2477	2479	2446	2437		1
6	2500	2450	2476	2588	2545	8347	2533		2
7	2611	2451	2492	2613	2589	8362	8400		3
8	8317	2487	8471	8338	8464	8465	8401		4
9	8385	2523	8501	8472	8484	8518	8500		5
10	8405	2585	8516	8541	8538		8511		6
11	8427	8459					8517		7
12									8
13									9
14									10
15									11
16									12
17									13
18									14
19									15
20									16
21									17
22									18
23									19
24									20
Current Month

Cell Formulas
Range	Formula
C2	C2	=DATE('Calender Setup'!P8,'Calender Setup'!P10,1)
C3:I3	C3	=C4
C4	C4	=$C$2-(WEEKDAY($C$2,1)-(start_day-1))-IF((WEEKDAY($C$2,1)-(start_day-1))<=0,7,0)+1
D4:I4	D4	=C4+1
C5:I24	C5	=IF(SUMIFS('2024'!$B:$B,'2024'!$G:$G,(CONCAT((TEXT(C$4,"DD-")),(TEXT($C$2,"MMM-YY")))),'2024'!$N:$N,$K5)=0,"",SUMIFS('2024'!$B:$B,'2024'!$G:$G,(CONCAT((TEXT(C$4,"DD-")),(TEXT($C$2,"MMM-YY")))),'2024'!$N:$N,$K5))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C88:I88,C109,C4:I4,C25:I25,C46:I46,C67:I67	Expression	=MONTH(C4)<>MONTH($C$2)	text	NO
C88:I88,C109,C4:I4,C25:I25,C46:I46,C67:I67	Expression	=OR(WEEKDAY(C4,1)=1,WEEKDAY(C4,1)=7)	text	NO

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.