Highlight selected cell with absence of employee

[Jagat Pavasia]

dear sir,
I have 5 employee in my sheet.
F4 to AJ4 have a date with yellow highlighted.
A5 to A9 have employee name.

I want that if my employee is absence in selected date then red highlighted in name only when that date is today.
I have screen shot below:

If today is 04/03/2023 (DD/MM/YYYY), then Screen shot Below

please help me to solve this...

 

[awoohaw]

is the date (1-31 the day of the month?) what is in the cell in G5:AJ9 to show if absent?

 

[awoohaw]

@Jagat Pavasia , please upload a mini workbook using the xl2bb add in. There is a link to it below.

 

[awoohaw]

try this:

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
1
2	[Cntrl] plus ;
3	2023-03-04
4						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
5	Employee-1(Name-1)				Employee-1				*
6	Employee-2(Name-2)				Employee-2
7	Employee-3(Name-3)				Employee-3
8	Employee-4(Name-4)				Employee-4				*
9	Employee-5(Name-5)				Employee-5
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A5:A9	Expression	=INDEX(F5:AJ5,DAY($A$3))="*"	text	NO