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 RUclips.. 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?
Hi all. I m working for medical lab reporting system build in excel. I need to do conditional formatting for a cell containing test value based on following criteria. Conditions: 1> There is a cell where user enters Gender either Male or Female. 2> Normal range for a Male for a particular lab test is between 10 and 20. 3> Normal range for a Female for a particular lab test is between 15 and 25. 4> Depending on the Gender and related value, the cell value should be formatted. 5> Example 1: if gender is Male and cell value is between 10 and 20, its normal and no formatting else format the test value cell. 6> Example 2: if gender is Female and cell value is between 15 and 25, its normal and no formatting else format test value cell. I m desperately waiting for helps.
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
Hello sir. First of all thanks to make this series its so helpful and your way of teaching nice. Actually i face a small problem that is in my excel sheet dont show dr symbol for the use of copying many cell.. Plz tell me the solution if already given in one of your video so plz just spell here... Bcz i m just starting your videos.. Thanks Hope response ASAP.
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
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
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.
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
Why the Mobile has been highlighted along with shoes? When were discussing about "Highlight Entire Record". We have applied condition for shoes only then it should have been shows the record for shoes only.
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..
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
hi, i would like to compare a cell value and highlight another cell value, but the cell i will be comparing will have a text and the other cell have a number. example i3 is having any text then m3 should be greater than 0. if it is not greater than zero then the cell should get highlighted. can anybody help me with this. TIA B Venkat
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..👏👏
I have looked for this to many videos, but eventually with you I learnt and become able to apply it. thank you.
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 RUclips.. Hats off!!
Your lessons on conditional formatting were crisp, simple and easy to understand; thank you 🙏
I thoroughly enjoyed and learnt a lot from your tutorial on advance conditional formatting. Many thanks sir! stay blessed!
You know how to teach. Thanks a million!
this my 80th video from your playlist
, will watch all 101. You are really great Mr Lalwani.
Thanks Lavender
And like that all of the Conditional Formatting lessons are finished, POGGERS!
Thank You!
Interesting... what an easy way to explain.. explaining in an easy manner is a true talent and expertise...
You teach the concepts in a simple & easy manner,Good Job
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
Marvellous video, thank you
Thank u so much for this useful tutorial. And u presenting method is very clear sir. Thanks a lot again...
Your teaching skills are Awwwwwwwsooommmeeee Sir...
Your explanations are great
Thank you very much for explaining well.
Very very nice explanation Sir and thanks a lot.
Tq bro...Ur teaching style is gud..
fantastic learning by pawan sir
Your explanation is very clear Sir 👌 thank you so much
very easy to understand sir
Thanks Sir
YOU ARE THE BEST.
Thank you so much...ur explanation is really very nice 👌🏻🙏🏻
Sorry to say sir ,but you are explaining how to apply formula in a proper way, we are here for formulas only
Thank you for excellent knowledge
It's very useful to everyone
I used to brush up my excel by watching his tutorials. I have one doubt. You can also use filter to get this easily
Precise and very useful
Excellent teaching sir. We want full new rules conditional formatting sir
you are my super hero
Good teacher!
Very nice outstanding explanation.
Very good sir😘
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.
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.
*Great Dude I need this touch display ...can u suggest where can I purchase this touch display*
@John Porter Bruh...
Useful videos
thanq so much brother i like ur videos so cool way you explain
Thank you😊😊😊😊😊
thank you so much
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
U R the best sir
one thing I have noticed his favourite colour is "ellow".
highlight entire row and Highlight Column and Row at same time both examples not working.
Great and good presentation 👌
Very nice brother. Good
thank you so much bhai.
Thank you
Very nice
Yea, but can you turn conditional formatting on and off tho?
i like the way you use a big screen
to get highlight for entire record 1:48
Salute u brother, really nice video
Thank you for teach me a tough thing
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
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...
Nice video however we can expand this part as it covers many more in conditional formating
REALLY VERY WELL EXPLAINED SIR , PLEASE UPLOAD VIDEOS FOR LARGE DATA SEARCH BOX
How can I gather the data found through the search to the top rows of the spreadsheet, since my excel sheet is very long?
woww ji,,,,Super
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 Sir, please upload a video over conditional formatting with excel VBA code. Thanks!
Sir, at 00:58, why only A5 is selected for comparing with the fixed cell? Highlighted cell can be any from the selected column...
i like this,,,very2 nice
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?
So the rule is to luck column put $ before alphabets & to luck row put dollar before numbers.
Very very sweet and simple way to explain a diffcult thing sir ji
😇😇😇😇
So Impressive !
Hi all. I m working for medical lab reporting system build in excel. I need to do conditional formatting for a cell containing test value based on following criteria.
Conditions:
1> There is a cell where user enters Gender either Male or Female.
2> Normal range for a Male for a particular lab test is between 10 and 20.
3> Normal range for a Female for a particular lab test is between 15 and 25.
4> Depending on the Gender and related value, the cell value should be formatted.
5> Example 1: if gender is Male and cell value is between 10 and 20, its normal and no formatting else format the test value cell.
6> Example 2: if gender is Female and cell value is between 15 and 25, its normal and no formatting else format test value cell.
I m desperately waiting for helps.
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
Sir You Are Looking Like Sonu Nigam
Hello sir. First of all thanks to make this series its so helpful and your way of teaching nice. Actually i face a small problem that is in my excel sheet dont show dr symbol for the use of copying many cell.. Plz tell me the solution if already given in one of your video so plz just spell here... Bcz i m just starting your videos..
Thanks
Hope response ASAP.
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
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
Very Nice , How can i format a part of row (Cells which are being used in formula) by coditional formatting and sumproduct formula. Thanks
Good...
How can I not highlight whole row when text is striked through
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.
I Love You
Sir Brilliant
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
Nice
How do i automatically color rows based on even or odd number dates?
Hello sir. Very good video. Can you please tell which board are you using
Thank you uuuuuuuu so much
Why the Mobile has been highlighted along with shoes? When were discussing about "Highlight Entire Record". We have applied condition for shoes only then it should have been shows the record for shoes only.
you are handsome and you are speaking so good in English
you can zoom the tool box used
Oke, but If I mix blue and yellow I want to get purple cell, not yellow.
great
Formula unable to see what you written in condition formatting
is this advance conditional formatting examples will work in office 10? please reply.
Thanks for your good plan teacher I could request you to teach me barcode full course
unable to get the results irrespective of using the same formula
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..
how to change the colour when the number is negative into red & when number is positive into blue in the same column.
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 ruclips.net/video/1sce8va1Yhg/видео.html
Can we use same on numbers
Please kindly show us the formulas you are entered in the conditional formatting dialog as my own is not formatting. Thanks
hi,
i would like to compare a cell value and highlight another cell value, but the cell i will be comparing will have a text and the other cell have a number.
example i3 is having any text then m3 should be greater than 0. if it is not greater than zero then the cell should get highlighted.
can anybody help me with this.
TIA
B Venkat