Excel How To Find Cells That Contain Specific Text

preview_player
Показать описание
This video demonstrates how to write a formula that finds specific text values within cells. We also use conditional formatting to highlight those cells.

Chapters in this video:
00:00 - Introduction
00:12 - SEARCH
01:01 - NOT / ISERROR
02:08 - Conditional Formatting

Also, check out these videos with time saving Excel Hacks:

Рекомендации по теме
Комментарии
Автор

Thank you! A comment about your videos: I appreciate your teaching style; straight into the subject matter with no waffle and your use of exercises that build scenarios as you go through. Cheers

davidtyrrell
Автор

Thank you for sequentially building the formula for Not/Iserror. Perfectly described for my brain! :)

tvrlytf
Автор

At last, I found your channel! Indeed, you are a good teacher! i can easily understand the lessons...though i think it will be better for learners like me to follow along and apply your lessons. Is it possible for you to provide the practice file ?thank you so much again...more power!looking forward to your next video...

carolinaforbes
Автор

Can you do it for multiple words that are written in a range of cells?

TheOriginalAryan