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?

 

[Norie]

Select E4 onwards, goto conditional formatting, select Formula is, enter this formula

=$A4=$C$1

and format as required.

 

[aka_krakur]

That worked...Thx...sometimes the most simple things just slip my memory on how to do them

 

[Barry Katcher]

Or, since the concatenate formula in column E always results in the first digits of the string being whatever is in column A, you can bypass column A altogether by using this conditional format in Column E:

=LEFT(E4,5)*1=$C$1