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))
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.
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?
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 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.
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…
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.
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).
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.
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!
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
@3:04 For those who didn't worked select the D1 cell insted of D2 it will work!!
Thankyou.
Great... No time waste to get knowledge. Thnanks.
Superb....searched a lot for this option,.....u helped me...thanks a lot!!⭐⭐⭐⭐⭐
Most welcome 😊
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))
All the other videos were crazy intricate. This was simple. Thank you very much!
I was looking for such format..
Thanks brother u have gave me all knowledge
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.👍👍
VERY VERY THANKFUL SIR JI
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.
You deserve more recognition. Thanks for the vid
Sir want an example if all cells in a row containing same word then row should be highlighted
Thank you
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?
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
Thanks very useful sir
Glad to hear that :)
Helpfully Video Thanks sir 😊
how did you create the drop down list box in a cell can you please show or give tutorial link?
After highlighting perticular row and column can we SUM all the highlighted values in a cell?? Any formula for this??
How can I highlight all different cells which are added to find a sum value ?
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?
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
The very Best of the best ✌️
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...
Hello sir can you tell me how to do the same thing in Google sheets
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
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.
Thank you sir !!
I'm sooooo lateeeeee😊😊😊
Kissess and hugs !
Superb as usual !!
Like always, You are the first one ☺️
How can I highlight multiple values at same time from sheet 2
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.
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 can I highlight if the text contain other than English text in cell? Thank you!
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.
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).
Thanks. How do I highlight custom numbers e.g 45.2?
Conditional Formatting > Highlight Cells Rules > Equal to
how do i8 get the dialoge box active on the D2 search for
Love ur vids
Excellent
Thank you! Cheers!
THANK YOUUUUUUUUUU
how to highlight only sales which containg product mars
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?
how to highlight cells that contains number from table range.
Please do zoom n show it
Mine isn't working
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.