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 Mar 27, 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 27 Mar 2017.
Chicago / Turabian VisiHow.com. "Highlight Matching Cells with Text in Excel." Accessed Mar 27, 2017. http://visihow.com/Highlight_Matching_Cells_with_Text_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu