Highlighting Values on One Sheet, Based on Reference Data From Entire Row of a Diff. Sheet

[AntAbbate]

Hello,

I currently have a 'map' of my car terminal with locations assigned to each cell (Picture a large parking lot). When it comes time to load a vessel, I am given a list of Locations and Ports of Discharge. What I am attempting to do is conditionally format the map so that any values found on the data (locations) sheet highlight any equal values found on the map. The Ports of Discharge will all be assigned their own color, and I realize I will most likely have to create multiple conditions (1 for each POD) to achieve this.

The goal is to have a map of my terminal where all the cargo that is to be loaded is color coordinated by port of discharge.

Currently, I can achieve the desired result on a cell to cell basis, which isn't helpful. When attempting to select an entire row as my reference data I am met with the below error.

Any input would be greatly appreciated, thank you!


Small section of the map with desired highlight result

\1

Example of data set

\1

Error received when selecting entire row as reference data

\1

SAMPLE YARD MAP.xlsx

[windy58]

A sample workbook would generate a better understanding of what you want.

The pictures do not give a lot of detail.

Windy

[AntAbbate]

Thank you, I have added a sample workbook.

SAMPLE YARD MAP.xlsx

[AntAbbate]

Any ideas???

[windy58]

Is the list on the Data sheet a complete list?

To make this work I extended the list for the last entry.