Conditional Format for two text values

[Kulo5856]

Dear Team,
I'm looking for the conditional format rule for mentioned below table

Name/ Date	Tue	Wed
02-08-2022	03-08-2022
XX	CIDCO-KVGC	JLNS
YY	TNCA	CIDCO-33
ZZ	HALDI	CIDCO-33

I need the person working on HALDI in Tuesday must be in different colour
IF TUE HALDI - i need formula for that

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Name/ Date	Tue	Wed
2	02/08/2022	03/08/2022
3	XX	CIDCO-KVGC	JLNS
4	YY	TNCA	CIDCO-33
5	ZZ	HALDI	CIDCO-33
6
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C5	Expression	=AND(A2="haldi",A$1="Tue")	text	NO

 

[Kulo5856]

Thanks for the quick reply, Worked fine sir

 

[Fluff]

Glad to help & thanks for the feedback.