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.
- 13Now, if the domain is available in column "D", it will be highlighted in column "C".Click "OK" again.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!
Video: Highlight Matching Cells with Text in Excel
Referencing this Article
If you need to reference this article in your work, you can copy-paste the following depending on your required format:
APA (American Psychological Association)
Highlight Matching Cells with Text in Excel. (2016). In VisiHow. Retrieved May 1, 2017, from http://visihow.com/Highlight_Matching_Cells_with_Text_in_Excel
MLA (Modern Language Association) "Highlight Matching Cells with Text in Excel." VisiHow, visihow.com/Highlight_Matching_Cells_with_Text_in_Excel Accessed 1 May 2017.
Chicago / Turabian VisiHow.com. "Highlight Matching Cells with Text in Excel." Accessed May 1, 2017. http://visihow.com/Highlight_Matching_Cells_with_Text_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu