Highlight cells containing a Specific Text or Number

5 Methods to highlight cells that contain a specific text or number are explained in this video.
🟠 Books on Excel xlncad.com/exc...
🟡 Get Office 365 Subscription microsoft-us.e...
🔵 Download my free ebook on Excel Macros eepurl.com/gpT0RD
🟢 Read my articles on Excel xlncad.com/
🚚Check my store on Amazon.
www.amazon.com...
Disclosure: Some of the links are Affiliate Links! If you buy something through one of those links, you won't pay a penny more, but we will get a small commission, which helps keep the lights on. Thank you for your support!
#HighlightTextExcel #HighlightNumberExcel

[@Mosa2491]

This must’ve been the 6th video I watched, and it’s the only method that worked. Thank you! Such a clear explanation

[@AjayAnandXLnCAD]

You're welcome!

[@saemakhatun2130]

I think this is the best video on conditional formatting ever! Thanks!

[@AjayAnandXLnCAD]

Thank you :)

[@davisellis7445]

i know Im randomly asking but does anyone know of a way to log back into an instagram account? I stupidly lost my password. I would appreciate any tips you can offer me!

[@judahkeith6748]

@Davis Ellis Instablaster ;)

[@davisellis7445]

@Judah Keith Thanks for your reply. I got to the site on google and I'm trying it out now. I see it takes quite some time so I will reply here later with my results.

[@Bennysam007]

@3:04 For those who didn't worked select the D1 cell insted of D2 it will work!! Thankyou.

[@KD1125]

Great... No time waste to get knowledge. Thnanks.

[@dilipkush.9315]

If I want to highlight only a particular word within a cell that contains many words/sentences in the cell. Then how

[@balamurugan.v]

If u know the answer, pls post the video link here

[@timhymer]

All the other videos were crazy intricate. This was simple. Thank you very much!

[@sushovandutta9864]

Excellent my dear friend. It's going to be a very very much useful thing for me and ultimately I found it at the right time. Great great.👍👍

[@MrKshinde6575]

I was looking for such format.. Thanks brother u have gave me all knowledge

[@rohinipatill8822]

Superb....searched a lot for this option,.....u helped me...thanks a lot!!⭐⭐⭐⭐⭐

[@AjayAnandXLnCAD]

Most welcome 😊

[@shivanisangal5521]

You deserve more recognition. Thanks for the vid

[@chanderpal7840]

VERY VERY THANKFUL SIR JI

[@Sahupra2]

Helpfully Video Thanks sir 😊

[@manjit.sarania]

Sir I'm following and and learning excel from you and you are a great teacher....it would be more helpful if your table data presents a bit more zoom to see early...shorts are ok

[@sohilbadami1]

Thanks very useful sir

[@AjayAnandXLnCAD]

Glad to hear that :)

[@jerryfriday8857]

Good day, I must admit it is a gift to stumble on this article, but however my challenges was not addressed. I have a work sheet with just a single column. I need a formula that will highlight the row above the cell if the cell contains a specific text. For example if A2 contains "great" A1 should be highlighted. Thank you so much while i await your response.

[@AjayAnandXLnCAD]

I hope you understood the formula explained at 6:42. You can change the formula like the following to meet your requirement. =ISNUMBER(SEARCH($E$2,$B3))

[@pinkyraj4965]

The very Best of the best ✌️

[@susannax4978]

Super clear video, but can I create the dynamic 'Enter the Text to Search for' cell for a string of text i.e. the cell may also contain other text? I only see that option ("text contains") when using option "Cell rules" but when creating a formula to determine which cells to highlight with the search field, there is no such option, only a possibility to look for an EXACT of the text. Any help, please?

[@jbmxcreations]

how did you create the drop down list box in a cell can you please show or give tutorial link?

[@MGOPAKUMAR]

How can I highlight all different cells which are added to find a sum value ?

[@rajuj8876]

Sir want an example if all cells in a row containing same word then row should be highlighted Thank you

[@10morrisonka]

I'm sooooo lateeeeee😊😊😊 Kissess and hugs ! Superb as usual !!

[@AjayAnandXLnCAD]

Like always, You are the first one ☺️

[@lalitkaushik1812]

I have data of more than 1k it's highlighting the row but I have to scroll down, any idea cursor should go there.

[@meganoraouf9482]

how do i8 get the dialoge box active on the D2 search for

[@raghu6067]

please help me. lets take an example of your table. how can i highlight - microsoft, youtube, quora " at one short. is there any formula for this. i can highlight quora using conditional formatiting but how can highlight those 3 in a table using conditional formatting. not entire row only specific texts(those 3).

[@prashantraj3478]

How can I highlight multiple values at same time from sheet 2

[@saarthaksharma1595]

Love ur vids

[@Dubcity72]

Thank you sir !!

[@usamamando]

Can we change the formatting (e.g. color) of some arbitrarily selected cells of a table in Word or Excel using a selection of combo box or dropdown list content control so that only the cells of the selected selection are formatted (active)... one color enough...

[@haakestad]

I have tried the last formula in a list of Stock Quotes. i.e. search for a stock that contains a word, but this does not work. I really don't know why this happens.

[@Lic.SashaRodriguez]

THANK YOUUUUUUUUUU

[@safezone6479]

Hello sir can you tell me how to do the same thing in Google sheets

[@ajusarda]

After highlighting perticular row and column can we SUM all the highlighted values in a cell?? Any formula for this??

[@ak3749]

Nice and very helpful videos sir 👍 If there is very big data I want the search cell itself should be highlighted if it in the big data list

[@sabarinathan8497]

My requirements: I have 620 line item A,b,c cell define about the product. A,b,c cell contain the product name. For ex “Mobile phone” these 2 words present in 3 cells how can I highlight… I tried this one but it work only for one word only…

[@balajitivatharangopika313]

Hi Sir, how can i select different rows with hilighted colour and copy the rows in another sheet

[@AjayAnandXLnCAD]

The Filter tool in Excel can be used to segregate colored cells. So, apply filter and then copy the filtered rows into another sheet.

[@balajitivatharangopika313]

@@AjayAnandXLnCAD Thank you very much for your best suggestions sir.

[@sankarnagboggula4490]

How can I highlight if the text contain other than English text in cell? Thank you!

[@meermeer2938]

Hello Ajay can you explain please how I can highlight the cell based on cell value when the number it's up and down ? thank you

[@SabWee1978]

Thank you so much for the explanation - easy to follow! 🤩 Is there a link where I can download the workbook where I can practice while following your video?

[@Gauoobin]

Thanks. How do I highlight custom numbers e.g 45.2?

[@AjayAnandXLnCAD]

Conditional Formatting > Highlight Cells Rules > Equal to

[@mahaboobhossain5076]

Excellent

[@AjayAnandXLnCAD]

Thank you! Cheers!

[@RAVICHANDRAN-vp5yu]

how can highlight (1234) this number any randomly like 3241, 2341, 4321... ( not only this 4digit any 4 number )

[@AjayAnandXLnCAD]

Can you please make it more clear?

[@tulshimaharjan2045]

how to highlight cells that contains number from table range.

[@Ali-uz8qg]

That is a superb step by step explanation. Today I learned something new in Excel about conditional formatting. But in my worksheet I have a different problem, and I am unable to find a solution (that is, if there is one). Problem example: Let's say I want to highlight 2 cells, (A1 and B1). *a)* Cell A1 needs to be highlighted only if it contains text, *not specific but any text.* This text will appear based on a logical formula (IF function). So if a text appears, the cell background should automatically highlight, if no text appears, then it should not highlight. *b)* In Cell B1, it's the same issue except the logical formula brings in a number *(not specific but any number).* So if a number greater than zero 0 appears, then the cell and number needs to be highlighted. If the cell value is zero, then the cell should not be highlighted. Please let me know if there is a solution to the problem. Thanks and appreciate.

[@bijoyadas7322]

Please do zoom n show it

[@sanjusaju4049]

Mine isn't working

[@vkjnrokis]

what about column with multiple rows to highligh different partial matches?

[@AjayAnandXLnCAD]

Can you please explain it with an example?

[@raydanish5785]

I GOT NAEM TRUE IN SOME CELLS , SO I MADE THIS RULE BUT IT HIGHLIGHT UPPER CELLS OF NAME TRUE

[@AbdurRahim-ot5gp]

Very bad Video because not clear.

[@juliogloria7573]

Not clear?? What do you mean by that? This was the best video that I watched about conditional formatting.