Highlight Matching Cells with Text in Excel
Edited by Djinu, VisiHow, Eng
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.
Steps
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13Now, if the domain is available in column "D", it will be highlighted in column "C".Click "OK" again.
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!
Video: Highlight Matching Cells with Text in Excel
If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.
Comments
Article Info
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu