Formatting Cells

[BGA]

I am trying to make a vacation request calendar/schedule on excel and need to format some cells.

Below are the cells i am trying to format. I want to be able to put an "x" under a specific date and the cell be filled yellow, but if i put "Y" over in the last column, the "x"s will be highlighted green instead of yellow.

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
													x	x	x	x	x	x	x	x											Y

Thank you in advance.

 

[fahad_ibnfurjan]

Formatting Cells.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
1	2025
2		Mar
3		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
4	Employee1						X	X							x	x	x	x	x	x	x	x											Y
5	Employee2	X	X	X	X	X	X	X	X											x	x	x	x	x	x	x	x
6	Employee3						X								x
Formatting Cells

Cell Formulas
Range	Formula
B3:AF3	B3	=IFERROR(DAY(DATEVALUE(SEQUENCE(,31)&B2&A1)),"")
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:AG6	Expression	=AND(UPPER(B4)="X",UPPER($AG4)="Y")	text	NO
B4:AG6	Expression	=AND(UPPER(B4)="X",UPPER($AG4)<>"Y")	text	NO

 

[Peter_SSs]

@fahad_ibnfurjan
There is no need for any of the UPPER functions in your formulas.

25 04 02.xlsm
	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
3		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
4	Employee1						X	X							x	x	x	x	x	x	x	x											Y
5	Employee2	X	X	X	X	X	X	X	X											x	x	x	x	x	x	x	x
6	Employee3						X								x
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:AF6	Expression	=AND(B4="X",$AG4="Y")	text	NO
B4:AF6	Expression	=AND(B4="X",$AG4<>"Y")	text	NO