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!
@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.
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
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.
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))
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?
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 ?
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.
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?
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.
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
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...
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.
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).
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…
This must’ve been the 6th video I watched, and it’s the only method that worked. Thank you! Such a clear explanation
You're welcome!
I think this is the best video on conditional formatting ever! Thanks!
Thank you :)
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!
@Davis Ellis Instablaster ;)
@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.
@3:04 For those who didn't worked select the D1 cell insted of D2 it will work!!
Thankyou.
All the other videos were crazy intricate. This was simple. Thank you very much!
You deserve more recognition. Thanks for the vid
I was looking for such format..
Thanks brother u have gave me all knowledge
Great... No time waste to get knowledge. Thnanks.
Superb....searched a lot for this option,.....u helped me...thanks a lot!!⭐⭐⭐⭐⭐
Most welcome 😊
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
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.👍👍
Thank you!
VERY VERY THANKFUL SIR JI
Thank you.
😀
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.
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))
The very Best of the best ✌️
Helpfully Video Thanks sir 😊
Thanks very useful sir
Glad to hear that :)
I'm sooooo lateeeeee😊😊😊
Kissess and hugs !
Superb as usual !!
Like always, You are the first one ☺️
boss thank you so much
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
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?
how did you create the drop down list box in a cell can you please show or give tutorial link?
Sir want an example if all cells in a row containing same word then row should be highlighted
Thank you
Thank you sir !!
THANK YOUUUUUUUUUU
Love ur vids
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 ?
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.
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?
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.
Excellent
Thank you! Cheers!
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
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...
I have data of more than 1k it's highlighting the row but I have to scroll down, any idea cursor should go there.
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
After highlighting perticular row and column can we SUM all the highlighted values in a cell?? Any formula for this??
Hello sir can you tell me how to do the same thing in Google sheets
How can I highlight multiple values at same time from sheet 2
How can I highlight all different cells which are added to find a sum value ?
Hi Sir, how can i select different rows with hilighted colour and copy the rows in another sheet
The Filter tool in Excel can be used to segregate colored cells. So, apply filter and then copy the filtered rows into another sheet.
@@AjayAnandXLnCAD Thank you very much for your best suggestions sir.
@@AjayAnandXLnCADhow can I highlight recurring themes? I am doing a qualitative study.
how do i8 get the dialoge box active on the D2 search for
Thanks. How do I highlight custom numbers e.g 45.2?
Conditional Formatting > Highlight Cells Rules > Equal to
If I want to highlight only a particular word within a cell that contains many words/sentences in the cell. Then how
If u know the answer, pls post the video link here
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.
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).
How can I highlight if the text contain other than English text in cell? Thank you!
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…
how to highlight only sales which containg product mars
how to highlight cells that contains number from table range.
Please do zoom n show it
Mine isn't working
how can highlight (1234) this number any randomly like 3241, 2341, 4321... ( not only this 4digit any 4 number )
Can you please make it more clear?
what about column with multiple rows to highligh different partial matches?
Can you please explain it with an example?
I GOT NAEM TRUE IN SOME CELLS , SO I MADE THIS RULE BUT IT HIGHLIGHT UPPER CELLS OF NAME TRUE
Bakwas video kuch nhi ho rha, iski wajah se fail Kiya hai exam mein
Very bad Video because not clear.
Not clear?? What do you mean by that? This was the best video that I watched about conditional formatting.