Conditional formula

[topi1]

I want conditional formula that will highlight a cell in the range C3:L12 in sheet4 that matches the following formula. Can someone please help? Thank you.

=INDEX(C3:L12, MATCH(Sheet3!D2, B3:B12, 0), MATCH(Sheet3!E2, C2:L2, 0))

 

[DanteAmor]

Is this what you need?

Sheet3:

DANTE AMOR
	A			D	E	F
1
2				R2	H3
3
Sheet3

Sheet4:

DANTE AMOR
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			H1	H2	H3	H4	H5	H6	H7	H8	H9	H10
3		R1
4		R2
5		R3
6		R4
7		R5
8		R6
9		R7
10		R8
11		R9
12		R10
13
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:L12	Expression	=MATCH(Sheet3!$D$2, $B:$B, 0)&"|"&MATCH(Sheet3!$E$2, $2:$2,0)=ROW()&"|"&COLUMN()	text	NO

 

[topi1]

Is this what you need?

Sheet3:

DANTE AMOR
	A			D	E	F
1
2				R2	H3
3
Sheet3

Sheet4:

DANTE AMOR
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			H1	H2	H3	H4	H5	H6	H7	H8	H9	H10
3		R1
4		R2
5		R3
6		R4
7		R5
8		R6
9		R7
10		R8
11		R9
12		R10
13
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:L12	Expression	=MATCH(Sheet3!$D$2, $B:$B, 0)&"|"&MATCH(Sheet3!$E$2, $2:$2,0)=ROW()&"|"&COLUMN()	text	NO

@DanteAmor Perfect. Thank you. Did not understand "stop if true" Part.

 

[DanteAmor]

Did not understand "stop if true" Part.

That is used when you have more rules, the rules are applied from the top down. For example, if you have 2 rules that apply to the same cell, but you want it to stop at the first format, then you activate the Stop if true box.
In this case it is not necessary to check the box.

 

[topi1]

That is used when you have more rules, the rules are applied from the top down. For example, if you have 2 rules that apply to the same cell, but you want it to stop at the first format, then you activate the Stop if true box.
In this case it is not necessary to check the box.

Understood. Thanks.

 

[Peter_SSs]

Unless column B and/or row 2 could have repeated values, you could also use this shorter option.

topi1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1
2			H1	H2	H3	H4	H5	H6	H7	H8	H9	H10
3		R1
4		R2
5		R3
6		R4
7		R5
8		R6
9		R7
10		R8
11		R9
12		R10
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:L12	Expression	=AND($B3=Sheet3!$D$2,C$2=Sheet3!$E$2)	text	NO

 

[topi1]

Unless column B and/or row 2 could have repeated values, you could also use this shorter option.

topi1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1
2			H1	H2	H3	H4	H5	H6	H7	H8	H9	H10
3		R1
4		R2
5		R3
6		R4
7		R5
8		R6
9		R7
10		R8
11		R9
12		R10
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:L12	Expression	=AND($B3=Sheet3!$D$2,C$2=Sheet3!$E$2)	text	NO

@Peter_SSs Thank you.

 

[Peter_SSs]

@Peter_SSs Thank you.

You're welcome. Glad to contribute.