Conditional Formatting - highlight range if cell matches another

[Jasesair]

I'm going wrong somewhere, but not too sure where. Conditional Formatting (CF) confuses me!

I'm wanting E10:G13 to highlight if E13 is the same as C3. As such, I've highlighted E10:G13 and in CF, I have entered =E13=$C$3, and of course set the highlight colour. I'm having no luck with this.

Any help would be much appreciated.

 

[etaf]

You need to change E13 to $E$13

=$E$13=$C$3

if you want all 4 rows to highlight for the condition in E13

But if you want just row 10 - when E10 matches C3 , row 11 when E11 matches c3 etc

if so then
change the formula to
$E10 = $C$3

That fixes the Column and so does not then test F , G

 

[etaf]

this is if you just want the 1 ROW to match if the row E matches C3

Book1
	A	B	C	D	E	F	G	H
2
3			2
4
5
6
7
8
9
10					1	4	6
11					2	4	6
12					1	4	6
13					2	4	6
14
15
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E10:G13	Expression	=$E10=$C$3	text	NO

BUT if you want ALL rows regardless to highlight if ANY value matches C3 in E10,E11,E12 or E13
then a countif should be used
=COUNTIF($E$10:$E$13,$C$3)>0

Book1
	A	B	C	D	E	F	G	H
2
3			2
4
5
6
7
8
9
10					1	4	6
11					1	4	6
12					1	4	6
13					2	4	6
14
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E10:G13	Expression	=COUNTIF($E$10:$E$13,$C$3)>0	text	NO