Conditional formatting question

[aka_krakur]

Here is a sample of a spreadsheet I have:

Book3
	A	B	C	D	E
1	UserInputCurrentIncidentNumber		44815
2
3	INCIDENT_NUMBER	CASE_NUMBER	PART_SEQUENCE	ACTUAL_DEVICE_CODE	ID
4	44815	1	1	1628	44815-1-1
5	44915	1	1	2284	44915-1-1
6	44915	1	1	X100	44915-1-1
7	44915	1	1	2284	44915-1-1
8	44915	1	1	X100	44915-1-1
9	46004	1	1	2284	46004-1-1
10	46004	1	1	X100	46004-1-1
11	46004	1	1	2284	46004-1-1
12	46004	1	1	X100	46004-1-1
13	46763	1	1	1179	46763-1-1
14	46934	1	1	2284	46934-1-1
15	46934	1	1	2284	46934-1-1
Sheet1

I would like column E (ID) to be conditionally formatted to turn yellow (as shown) if/when cell in column A = C1

So for the above example since A4 = C1 cell E4 gets highlighted Yellow.

Is this possible?
If so, how?

 

[BrianB]

Try this one :- [Formula Is]

=TEXT(B4,"00000")=LEFT(E4,5)

 

[barry houdini]

Select E4:E15 and use the formula

=A4=C$1