smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In column A (A3:A600) I have a customer names and in column B (B3:B600) customer's cities (their current location).
In cell C3 there is a 'referent city'. When customer is in 'referent city' I need to highlight his previous appearence (column A).
example.
<tbody>
</tbody>
explanation: Referent city (cell C3) is Vienna. Customer B.Duncan was in Vienna (cells A7 and B7), so his previous appearance was in cell A5 - highlight cell A5.
Same story for L.Clarkson (A9 and B9) so highlight his previous appearance in cell A4.
In column A (A3:A600) I have a customer names and in column B (B3:B600) customer's cities (their current location).
In cell C3 there is a 'referent city'. When customer is in 'referent city' I need to highlight his previous appearence (column A).
example.
A | B | C | |
1 | |||
2 | Customer | City | Ref. City |
3 | J.Cain | Rome | Vienna |
4 | L.Clarkson | London | |
5 | B.Duncan | Berlin | |
6 | Y.Larouci | Melbourne | |
7 | B.Duncan | Vienna | |
8 | J.Cain | Amsterdam | |
9 | L.Clarkson | Vienna |
<tbody>
</tbody>
explanation: Referent city (cell C3) is Vienna. Customer B.Duncan was in Vienna (cells A7 and B7), so his previous appearance was in cell A5 - highlight cell A5.
Same story for L.Clarkson (A9 and B9) so highlight his previous appearance in cell A4.