Highlight Matching Cells with Text in Excel

Edited by Djinu, VisiHow, Eng, Anonymous

You're watching VisiHow. In this video, we're going to show you how to highlight a cell if its text matches another cell in Excel. In this video, we have two columns of data: column "D" with domain names that are currently available and column "C" with all of the domain names that we've searched. We want to highlight column "C" if the domain name is available.

Was this helpful? Yes | No | I need help

Highlight a cell if text matches another cell.mp4-canvas110 27299.jpg

Ad

Steps

  1. 1
    Click column "C" to highlight it.
    Highlight a cell if text matches another cell.mp4-canvas23 745243.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  2. 2
    Click "Conditional Formatting".
    Highlight a cell if text matches another cell.mp4-canvas29 197998.jpg
    Advertisement
    Was this step helpful? Yes | No | I need help

  3. 3
    Click "Manage Rules..."
    Highlight a cell if text matches another cell.mp4-canvas31 757993.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Then, click the "Show formatting rules for" drop-down menu.
    Then, check "Current Selection".
    Highlight a cell if text matches another cell.mp4-canvas34 626992.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    To create a new rule, click the plus button in the bottom left-hand corner of the window.
    Highlight a cell if text matches another cell.mp4-canvas36 08509.jpg
    Was this step helpful? Yes | No | I need help

  6. 6
    Click the "Style" drop-down menu and "Classic".
    Highlight a cell if text matches another cell.mp4-canvas41 320991.jpg
    Was this step helpful? Yes | No | I need help

  7. 7
    Click the second drop-down menu.
    Then, click "Use a formula to determine which cells to format".
    Highlight a cell if text matches another cell.mp4-canvas45 560991.jpg
    Was this step helpful? Yes | No | I need help

  8. 8
    Click the third drop-down menu.
    Highlight a cell if text matches another cell.mp4-canvas47 58092.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    Type the formula "=countif($d$2:$d$500,c2)".
    In this formula, the "$" sign means that it will have the absolute reference to the "D2" cell, that the reference is ended at the cell "D500", and that the highlighted cell will be "C2".
    Highlight a cell if text matches another cell.mp4-canvas91 00899.jpg
    Was this step helpful? Yes | No | I need help

  10. 10
    Click "Format with".
    Highlight a cell if text matches another cell.mp4-canvas95 37491.jpg
    Was this step helpful? Yes | No | I need help

  11. 11
    For this tutorial, click "green fill with dark green text".
    Highlight a cell if text matches another cell.mp4-canvas96 977058.jpg
    Was this step helpful? Yes | No | I need help

  12. 12
    Then, click "OK".
    Highlight a cell if text matches another cell.mp4-canvas99 16599.jpg
    Was this step helpful? Yes | No | I need help

  13. 13
    Click "OK" again.
    Now, if the domain is available in column "D", it will be highlighted in column "C".
    Highlight a cell if text matches another cell.mp4-canvas101 733738.jpg
    Was this step helpful? Yes | No | I need help

    Advertisement

That was how to highlight a cell if the information matches the information in another column. If you have any questions or comments, please leave them in the space below. Thanks for watching VisiHow!

Was this helpful? Yes | No | I need help

Video: Highlight Matching Cells with Text in Excel

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,700 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Highlight Matching Cells with Text in Excel"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 695 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No