Hi.... Your tutorials are very precise, crisp & enlightening. The style of teaching is impeccable & most importantly the video length is the most optimum amongst others one can find on same topic on UA-cam.. Hats off!!
very very,Thanks!!Sir,Every remember kind of mind and good behaviour of sir.I don't forget in my life.I live in myanmar.Your learning skill is more professional.I am visit to myanmar.Forever Thanks Sir,Best regards, Tun Tun Win
Hi , brother Pawan , your every presentation is excellent to understand easily. You are requested to present a video regarding Condotional Formating such as bellow. Suppose there are 5 subjects in a class. Condition of Pass is.. Pass Mark is 40 in each subject and aggregate mark is 50 in total. So how can I formate and highlight the row is passed in such condition.
Please make a video of conditional formatting for highlighting using a new role when a drop down box is considered.Like there are 5 companies and I create a dropdown box and when I select a particular comapany from the list it gets highlighted and so on
I have data of dimensions. Like in one cell I have 8.5*6.4*2.1 (i.e. length*width* height) now I have one criteria of dimension so how can I highlight my all dimensions according to that criteria because I want less than or equal to criteria
Hi- I have a data table in excel whose output shows a company's profits based on two variables (Per unit profit and units sold). The column and row headers of the table list a range of possible variables. I can change those variables and sometimes the table shows the same profit based on different combinations of the two variables. How can I have the conditional highlighting only apply to the output which corresponds to the two variables I chose, rather than highlighting every instance?
Hello brother i thoroughly enjoy learning from your videos. I have a question in this particular functionality though. In this scenario, we hav a single word in a single cell that we are formatting. What if i have a task to categorize by searching for a single keyword from a sentence. How do i highlight and count the frequency of occurrence of it. Hope you see my comment and help me out with this task. thnq v much
what is the conditional format formula for when LTP(last traded price) changes nearest values to be highlighted in resistance values r3, r2, r1, and support values s1,s2 &s3
please tell if I want to highlight a dependent cell on the basis of second cell that satisfies my need. e.g How can I highlight a dependent cell if a cell it is depending upon becomes ''0'' or any number that I want either ''1'' ''2'' ''3'' or any.
good morning boss. Can you show us how I change the background color on the specific word? for example if I select Confirm in DROP down selection in PHP then it should become green
Sir, I want to highlight the row without using any particular value..i.e., if I enter any value or date or anything in a particular cell, the row containing that cell should get highlighted..kindly advise how to do this
I am unable to do conditional formating for my excel- i want to get a color gradient table based on the occurence of the topic ie. i prepared a list of weak topic in each mock, want the sheet to get intensified in color with increasing frequency in subsequen mock. pls help..
Mr. Pawan lalwani sir ji ur teaching style is vry good but wat u hv written in data base is nt showing clearly ...i thnk its a camera problm pllzz solve the problm sir
I'm really want say thank you, It's very simple way to explain the conditional formatting and its very help for who really want it..👏👏
Hi.... Your tutorials are very precise, crisp & enlightening. The style of teaching is impeccable & most importantly the video length is the most optimum amongst others one can find on same topic on UA-cam.. Hats off!!
Your lessons on conditional formatting were crisp, simple and easy to understand; thank you 🙏
I have looked for this to many videos, but eventually with you I learnt and become able to apply it. thank you.
I thoroughly enjoyed and learnt a lot from your tutorial on advance conditional formatting. Many thanks sir! stay blessed!
this my 80th video from your playlist
, will watch all 101. You are really great Mr Lalwani.
Thanks Lavender
You know how to teach. Thanks a million!
You teach the concepts in a simple & easy manner,Good Job
Marvellous video, thank you
Interesting... what an easy way to explain.. explaining in an easy manner is a true talent and expertise...
very very,Thanks!!Sir,Every remember kind of mind and good behaviour of sir.I don't forget in my life.I live in myanmar.Your learning skill is more professional.I am visit to myanmar.Forever Thanks Sir,Best regards, Tun Tun Win
your class is excellent and gives adequate opportunity for learners
very easy to understand sir
Thank u so much for this useful tutorial. And u presenting method is very clear sir. Thanks a lot again...
*Great Dude I need this touch display ...can u suggest where can I purchase this touch display*
@John Porter Bruh...
Your teaching skills are Awwwwwwwsooommmeeee Sir...
Your explanations are great
fantastic learning by pawan sir
Thank you very much for explaining well.
Your explanation is very clear Sir 👌 thank you so much
Tq bro...Ur teaching style is gud..
Very very nice explanation Sir and thanks a lot.
Thank you for excellent knowledge
And like that all of the Conditional Formatting lessons are finished, POGGERS!
Thank You!
Thanks Sir
Precise and very useful
Useful videos
It's very useful to everyone
YOU ARE THE BEST.
Thank you so much...ur explanation is really very nice 👌🏻🙏🏻
Very nice outstanding explanation.
We would very much appreciate it if you would kindly show us the formulas you are entering in the conditional formatting dialog boxes.
zoom in
lazy mofos......
These are auto formulas by default in excel, you only need to select option.
Good teacher!
Excellent teaching sir. We want full new rules conditional formatting sir
Hi , brother Pawan , your every presentation is excellent to understand easily. You are requested to present a video regarding Condotional Formating such as bellow.
Suppose there are 5 subjects in a class. Condition of Pass is.. Pass Mark is 40 in each subject and aggregate mark is 50 in total. So how can I formate and highlight the row is passed in such condition.
I used to brush up my excel by watching his tutorials. I have one doubt. You can also use filter to get this easily
you are my super hero
thank you so much
Very good sir😘
thanq so much brother i like ur videos so cool way you explain
Very nice
Thank you😊😊😊😊😊
Great and good presentation 👌
Thank you
thank you so much bhai.
Very nice brother. Good
U R the best sir
Thank you for teach me a tough thing
Yea, but can you turn conditional formatting on and off tho?
Sir, at 00:58, why only A5 is selected for comparing with the fixed cell? Highlighted cell can be any from the selected column...
Sorry to say sir ,but you are explaining how to apply formula in a proper way, we are here for formulas only
highlight entire row and Highlight Column and Row at same time both examples not working.
i like this,,,very2 nice
How can I gather the data found through the search to the top rows of the spreadsheet, since my excel sheet is very long?
Salute u brother, really nice video
REALLY VERY WELL EXPLAINED SIR , PLEASE UPLOAD VIDEOS FOR LARGE DATA SEARCH BOX
i like the way you use a big screen
So Impressive !
Nice
to get highlight for entire record 1:48
great
Please make a video of conditional formatting for highlighting using a new role when a drop down box is considered.Like there are 5 companies and I create a dropdown box and when I select a particular comapany from the list it gets highlighted and so on
I have data of dimensions. Like in one cell I have 8.5*6.4*2.1 (i.e. length*width* height) now I have one criteria of dimension so how can I highlight my all dimensions according to that criteria because I want less than or equal to criteria
woww ji,,,,Super
Nice video however we can expand this part as it covers many more in conditional formating
Good...
one thing I have noticed his favourite colour is "ellow".
i like you saying "yellow color to aellow color, my daughter also say aellow,,,...that means she will also become intelligent like you..
anjali goorha coz his actually the real father...
Hi Sir, please upload a video over conditional formatting with excel VBA code. Thanks!
nice
you can zoom the tool box used
I Love You
Sir Brilliant
How can I not highlight whole row when text is striked through
Hi, you are doing a great job but please mention your name either at the beginning or at the end, so that can know you by your name at least.
Hi- I have a data table in excel whose output shows a company's profits based on two variables (Per unit profit and units sold). The column and row headers of the table list a range of possible variables. I can change those variables and sometimes the table shows the same profit based on different combinations of the two variables. How can I have the conditional highlighting only apply to the output which corresponds to the two variables I chose, rather than highlighting every instance?
Thank you uuuuuuuu so much
Can we use same on numbers
Hello brother i thoroughly enjoy learning from your videos. I have a question in this particular functionality though. In this scenario, we hav a single word in a single cell that we are formatting. What if i have a task to categorize by searching for a single keyword from a sentence. How do i highlight and count the frequency of occurrence of it. Hope you see my comment and help me out with this task. thnq v much
Very very sweet and simple way to explain a diffcult thing sir ji
😇😇😇😇
Formula unable to see what you written in condition formatting
Sir You Are Looking Like Sonu Nigam
what is the conditional format formula for when LTP(last traded price) changes nearest values to be highlighted in resistance values r3, r2, r1, and support values s1,s2 &s3
How can we get excel files in used lesson?
thanks bro
🙏🙏
you are handsome and you are speaking so good in English
please tell if I want to highlight a dependent cell on the basis of second cell that satisfies my need. e.g How can I highlight a dependent cell if a cell it is depending upon becomes ''0'' or any number that I want either ''1'' ''2'' ''3'' or any.
How do i automatically color rows based on even or odd number dates?
Thank you boss
good morning boss. Can you show us how I change the background color on the specific word? for example if I select Confirm in DROP down selection in PHP then it should become green
Hello sir. Very good video. Can you please tell which board are you using
Thanks for your good plan teacher I could request you to teach me barcode full course
Sir, I want to highlight the row without using any particular value..i.e., if I enter any value or date or anything in a particular cell, the row containing that cell should get highlighted..kindly advise how to do this
You will need to use VBA to highlight the row, based on the active cell. try this video ua-cam.com/video/1sce8va1Yhg/v-deo.html
Very Nice , How can i format a part of row (Cells which are being used in formula) by coditional formatting and sumproduct formula. Thanks
Which type of board you are using ..??
I am unable to do conditional formating for my excel-
i want to get a color gradient table based on the occurence of the topic ie. i prepared a list of weak topic in each mock, want the sheet to get intensified in color with increasing frequency in subsequen mock. pls help..
Can you please explain, formatting rows or columns, with partial text
How to highlight only one cell that belong to product & country.
unable to get the results irrespective of using the same formula
Oke, but If I mix blue and yellow I want to get purple cell, not yellow.
Mr. Pawan lalwani sir ji ur teaching style is vry good but wat u hv written in data base is nt showing clearly ...i thnk its a camera problm pllzz solve the problm sir