aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
Here is a sample of a spreadsheet I have:
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?
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?