Share via

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

Anonymous
2023-06-26T18:50:33+00:00

I am creating a running document that will show the current open POs our company has on one tab and on the second tab is all closed POs. How can I highlight the cells on the first tab if the PO #s corresponds with the updating list on the second tab.

Invoice Tracking.xlsx

This is a draft document that can bed edited and changed. Would you be able to help assist with the formula?

PII is mask by MSFT

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-27T07:58:19+00:00

    Hi respected Caitlin Moulthrop,

    Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

    And I appreciate your kind words.

    See my below formula in column C, D, E.

    =COUNTIF('PO #s'!A:A,B2)>0

    =COUNTIF('PO #s'!A:A,C2)>0

    =COUNTIF('PO #s'!A:A,D2)>0

    =COUNTIF('PO #s'!A:A,D2)>0

    Also, here I create a sample file for you, you may access via PM. You can access PM from the top right corner of this page, as shown in image below:

    Image

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-06-26T21:12:41+00:00

    Thank you, unfortunately, I have not been able to make your formulas work for what I am needing.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2023-06-26T20:59:18+00:00

    Hi respected Caitlin Moulthrop,

    Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

    And I appreciate your kind words.

    Based on my test if you enter the PO number in your column C, D, E **** etc it will **** highlight a cell if the same number is found. Here you can see in your sample wordbook, I type/enter some PO number in column C, D and use the same Formula:

    ![](https://learn-attachment.microsoft.com/api/attachments/7f0efc42-dd63-4fcb-bba4-4e0044ed289b?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/47e1b17c-2805-449b-aaf9-26946244766b?platform=QnA" rel="ugc nofollow">

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-06-26T20:17:34+00:00

    Thank you Waqas,

    Yes, this works: =COUNTIF('PO #s'!A1:A9, B3)>0

    I tried to alter it to also apply to all of Column B, C, D, E on tab 1, and capturing all of column A on tab 2. However, I was not able to make that work. Below are the formulas I added to the conditional formatting that then returned nothing in all columns

    Was this answer helpful?

    0 comments
  5. Anonymous
    2023-06-26T19:54:25+00:00

    Dear respected Caitlin Moulthrop,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, you may use below formula to highlight a cell if the same number is found on another tab (PO).

    Click on Home> Conditional Formatting > New Rule > Use formula to determine which cells to format

    =COUNTIF(PO!A1:A9, B2)>0

    Or ****

    =ISNUMBER(MATCH(B2, PO!A1:A9, 0))

    In your Excel workbook:

    =COUNTIF('PO #s'!A1:A9, B3)>0

    If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    0 comments