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 CZcams.. 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
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
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?
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
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
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
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.
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
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.
Hi. I have 4 cells with percentages in them. I want for format the first cell only, if the value of that cell is greater/lesser than the value in the other cells. Blue if it is greater, and yellow if it is lesser. This should only be done if the first cell is greater/lesser than all the other 3 cells, not if it is greater/lesser than one or two other cells only. And then I will need to copy this conditional formatting to other cells in the same column.Please help.
@@TekhXpert Thank you. Unfortunately that query was 2 years old. I now have something else in 'Conditional Formatting', that I need help with; how do I 'Left Align' a cell in conditional formatting, based on the value in it?
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.
Dear sir, I want to know how can i highlight red color in a column or cells once its condition in (-) minus sign.. Let me explain my view. e.g. I want to make a project where Sales Data is compared between two years. For example December 2018 sale was INR 2000 and December 2019 sale is INR 1500, Rs 2000-Rs 1500=Rs 500 deficit or d-growth in 2019. How can i make a condition that if sales figure is less than last year than result should be display or highlight as (-) minus sign with red color of font or cell.. Hope you understand my question.. i will be grateful to you to make a video in this regard.. Thank u 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..👏👏
I have looked for this to many videos, but eventually with you I learnt and become able to apply it. thank you.
Your lessons on conditional formatting were crisp, simple and easy to understand; 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 CZcams.. Hats off!!
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
I thoroughly enjoyed and learnt a lot from your tutorial on advance conditional formatting. Many thanks sir! stay blessed!
You teach the concepts in a simple & easy manner,Good Job
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
Thank u so much for this useful tutorial. And u presenting method is very clear sir. Thanks a lot again...
Marvellous video, thank you
And like that all of the Conditional Formatting lessons are finished, POGGERS!
Thank You!
Your teaching skills are Awwwwwwwsooommmeeee Sir...
Your explanations are great
Your explanation is very clear Sir 👌 thank you so much
Tq bro...Ur teaching style is gud..
Thank you very much for explaining well.
very easy to understand sir
Very very nice explanation Sir and thanks a lot.
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.
Thanks Sir
fantastic learning by pawan sir
Thank you so much...ur explanation is really very nice 👌🏻🙏🏻
YOU ARE THE BEST.
It's very useful to everyone
Thank you for excellent knowledge
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
*Great Dude I need this touch display ...can u suggest where can I purchase this touch display*
@John Porter Bruh...
thanq so much brother i like ur videos so cool way you explain
Good teacher!
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.
Thank you😊😊😊😊😊
you are my super hero
Very nice outstanding explanation.
thank you so much
Thank you
Very good sir😘
Useful videos
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
thank you so much bhai.
REALLY VERY WELL EXPLAINED SIR , PLEASE UPLOAD VIDEOS FOR LARGE DATA SEARCH BOX
Thank you for teach me a tough thing
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.
highlight entire row and Highlight Column and Row at same time both examples not working.
Great and good presentation 👌
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...
Very nice brother. Good
i like the way you use a big screen
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
Nice video however we can expand this part as it covers many more in conditional formating
Salute u brother, really nice video
Very nice
Sorry to say sir ,but you are explaining how to apply formula in a proper way, we are here for formulas only
Very very sweet and simple way to explain a diffcult thing sir ji
😇😇😇😇
So Impressive !
i like this,,,very2 nice
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 Love You
Sir Brilliant
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 Sir, please upload a video over conditional formatting with excel VBA code. Thanks!
Thank you uuuuuuuu so much
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?
Yea, but can you turn conditional formatting on and off tho?
Hello sir. Very good video. Can you please tell which board are you using
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 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
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
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
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
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.
great
Thank you boss
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.
you are handsome and you are speaking so good in English
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 czcams.com/video/1sce8va1Yhg/video.html
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.
thanks bro
Hi. I have 4 cells with percentages in them. I want for format the first cell only, if the value of that cell is greater/lesser than the value in the other cells. Blue if it is greater, and yellow if it is lesser. This should only be done if the first cell is greater/lesser than all the other 3 cells, not if it is greater/lesser than one or two other cells only. And then I will need to copy this conditional formatting to other cells in the same column.Please help.
This is a good question. It can be done. Today I will upload the lecture of Conditional Formatting on my channel and will cover your question in that.
@@TekhXpert Thank you. Unfortunately that query was 2 years old. I now have something else in 'Conditional Formatting', that I need help with; how do I 'Left Align' a cell in conditional formatting, based on the value in it?
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.
Good...
Thanks for your good plan teacher I could request you to teach me barcode full course
Nice
Oke, but If I mix blue and yellow I want to get purple cell, not yellow.
Dear sir, I want to know how can i highlight red color in a column or cells once its condition in (-) minus sign.. Let me explain my view. e.g. I want to make a project where Sales Data is compared between two years. For example December 2018 sale was INR 2000 and December 2019 sale is INR 1500, Rs 2000-Rs 1500=Rs 500 deficit or d-growth in 2019. How can i make a condition that if sales figure is less than last year than result should be display or highlight as (-) minus sign with red color of font or cell.. Hope you understand my question.. i will be grateful to you to make a video in this regard.. Thank u sir.
=IF(A1
I am also looking for the same video
How do i automatically color rows based on even or odd number dates?
to get highlight for entire record 1:48
one thing I have noticed his favourite colour is "ellow".
🙏🙏
is this advance conditional formatting examples will work in office 10? please reply.
So the rule is to luck column put $ before alphabets & to luck row put dollar before numbers.
Can you please explain, formatting rows or columns, with partial text
you can zoom the tool box used
how to change the colour when the number is negative into red & when number is positive into blue in the same column.
How can I not highlight whole row when text is striked through