How to highlight a cell if the same number is found on another tab

Littleladyk 

To highlight cells in the "Routing" tab column starting at A4 based on whether the same location number appears in the "Select" tab column A, you can use conditional formatting with a formula. Here's how you can set it up:

1. Go to the "Routing" tab.

2. Select the range of cells in column A starting from A4 where you want the conditional formatting to apply.

3. Go to the "Home" tab on the Excel ribbon.

4. Click on "Conditional Formatting" in the "Styles" group, then select "New Rule" from the dropdown menu.

5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."

6. Enter the following formula in the formula field:

=COUNTIF(Select!$A:$A, A4)>0

This formula checks if the value in the current cell (in the "Routing" tab) exists in column A of the "Select" tab.

7. Click on the "Format" button to choose the formatting style you want to apply to the highlighted cells.

8. After selecting the formatting, click "OK" to apply the conditional formatting rule.

9. Click "OK" again to close the "New Formatting Rule" dialog box.

Now, the cells in column A of the "Routing" tab, starting from A4, will be highlighted if the same location number appears in column A of the "Select" tab.

Make sure that the references to the "Select" tab and the ranges are correct in the formula. If your Excel file is in SharePoint, you should be able to access it and apply the conditional formatting as described above. If you encounter any issues, feel free to ask for further assistance!