How To Highlight Rows Based On Specific Text In Excel

How To Highlight Rows Based On Specific Text In Excel
In this excel tutorial, I’ll explain an interesting way to highlight row if cell contains specific text. You can also highlight rows in excel based on value within your selection or if the entire row. I’ll be using conditional formatting to solve this.
If you apply the conditional formatting to a selection then it will highlight rows within that selection and if you apply this to entire worksheet then it will mark the entire row.
Our challenge here is to create a dynamic highlight option that we create once will work until we remove it. In this case I’ve highlighted rows based on a specific text that I have on another cell. This dynamic formatting checks if the specific text that is in the cell we have selected matches or not. If it matches then the entire row will be highlighted with the color we select and if not, then nothing happens.
This tutorial will be very helpful if you have a transaction list and you want to locate or highlight every transaction from a specific buyer of vendor. Now let’s follow the steps below to apply conditional formatting if cell contains specific text and highlight it with pre-defined color.
Step 1: Select the entire worksheet (To highlight entire row) or a selection where you’ll have data (To highlight rows within that selection)
Step 2: Click on “conditional formatting” and then “new rule”
Step 3: Click on “Select formula to specify which cells to format”
Step 4: Now write the first cell no. of the column where you need to match your data then write = (Equal to) and then the specific text or cell number where you’ll have your specific text.
Step 5: Click on format and select the highlight color from there and click Ok Twice.
Done. This is how we change of a row color based on a text value in another cell.
Notes:
In step 4 you need to write the cell number of the column where you need to check specific text will have to write in this format $C2 not $C$2 or C2. All you need to remember is that $C means the column number is fixed, it will not change. And the row number here will change and check if any cell has the text, you specified and then take action.
#HighlightRow #BasedOnCellValue
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG

[@mitchellfamily90]

I've watched 15 videos and NO ONE described this as fast or as easily as you did!!! WELL DONE

[@Excel10tutorial]

Thanks a million for your comment. I'm glad you liked my videos.

[@MOBASHHA]

Thanks a million, I been searching in the internet and no one solved my issue with Highlighting the entire raws with specific word except you in fast and easy way.

[@Excel10tutorial]

I'm glad you like it. Please subscribe and be in touch.

[@khattakrashid6797]

👍 VERY QUICK ,TO THE POINT , IN EASY WAY THNKS ALOT

[@Excel10tutorial]

Glad it helped

[@joshvenroy1931]

Bless your soul for this

[@Excel10tutorial]

Thanks a million Please subscribe and share

[@jasonsupreme1980]

Hi thanks for the tutorial but i'm trying to find a away to highlight a "Row" that contains one or more string of text in a single cell, for example if we look at your table shown in the video you have the word "Transfer_To" in a single cell, how can I highlight all the "Rows" that contain the word "To" in it?

[@zanychay4144]

thank you so much. big help to me.

[@Excel10tutorial]

You're welcome

[@Plookiss]

Perfect thanks!

[@Excel10tutorial]

You're welcome!

[@mickysmall143]

Great Brother 👌

[@Excel10tutorial]

Thank you so much 😀

[@LionofAllah-37]

Can we do the search in search box for multiple columns or it have to be on one column only

[@Munjal_magarvadiya]

You are amazing

[@Excel10tutorial]

Thanks

[@user-ub9lz8gk5y]

EXCELLENT

[@Excel10tutorial]

Many thanks!

[@azhkel]

nice content sir

[@Excel10tutorial]

I'm glad you like it

[@azhkel]

new subscriber here

[@Excel10tutorial]

Thanks a million