Highlight cells containing a Specific Text or Number

[@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.

[@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

[@MrKshinde6575]

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

[@timhymer]

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

[@KD1125]

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

[@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.👍👍

[@jbmxcreations]

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

[@richardreid4434]

Awesome. Thanks so much.

[@dahangri]

Can you help me select or filter out capital-lettered words from small-lettered words in Excel, e.g., "JOHN vs. John?" In the first word, all letters are Capital, while in the second word, only the first letter is Capital, and the rest of the letters are small.

[@jidesh1978]

Bro If i wanted search a particular number in a column(1000 of number on that column) to be search and highlighted in a different color how we can do pls explain ?

[@tejalnandanwar1781]

Hi can u please help me with one of my query? I want to give a set of words in excel which is more than 1000 words., and that particular words should get highlighted if it is present. How to do that????

[@santoshkumars1156]

Hi sir how highlight duplicate values only from beginning word ex items name staring with Gillette mach 3 trbo and below name is Gillette presto. I need to highlight duplicate value only for Gillette name. Plz help me

[@trendy_nails]

Thank you!

[@meganoraouf9482]

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

[@Raghu-Nandan]

Thank you.

[@AjayAnandXLnCAD]

😀

[@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

[@Sahupra2]

Helpfully Video Thanks sir 😊

[@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))

[@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?

[@chanderpal7840]

VERY VERY THANKFUL SIR JI

[@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...

[@pinkyraj4965]

The very Best of the best ✌️

[@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.

[@10morrisonka]

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

[@AjayAnandXLnCAD]

Like always, You are the first one ☺️

[@mirhaider7365]

Dear brother can you please tell me How can we fine a specific text and highlight to text not cell.... Please tell me this

[@MGOPAKUMAR]

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

[@sohilbadami1]

Thanks very useful sir

[@AjayAnandXLnCAD]

Glad to hear that :)

[@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

[@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.

[@Yepyep341]

@@AjayAnandXLnCADhow can I highlight recurring themes? I am doing a qualitative study.

[@MdAl-Amin-st2vt]

boss thank you so much

[@safezone6479]

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

[@prashantraj3478]

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

[@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).

[@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

[@ajusarda]

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

[@KiloBravo90]

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

[@AjayAnandXLnCAD]

Conditional Formatting > Highlight Cells Rules > Equal to

[@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.

[@Jay01-o5y]

how to highlight only sales which containg product mars

[@rajuj8876]

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

[@RazorCrest71]

Thank you sir !!

[@saarthaksharma1595]

Love ur vids

[@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

[@SankarNag_B]

How can I highlight if the text contain other than English text in cell? 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?

[@Lic.SashaRodriguez]

THANK YOUUUUUUUUUU

[@mahaboobhossain5076]

Excellent

[@AjayAnandXLnCAD]

Thank you! Cheers!

[@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…

[@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.

[@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?

[@vkjnrokis]

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

[@AjayAnandXLnCAD]

Can you please explain it with an example?

[@tulshimaharjan2045]

how to highlight cells that contains number from table range.

[@sanjusaju4049]

Mine isn't working

[@bijoyadas7322]

Please do zoom n show it

[@raydanish5785]

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

[@tiashadas4381]

Bakwas video kuch nhi ho rha, iski wajah se fail Kiya hai exam mein

[@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.