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.
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?
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
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.
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 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 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?
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.
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 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
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.
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
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.
You can protect the sheet. And in property window of cell (CTRL+1), in protection tab , there is an option whether you want to lock the cell or not? By doing this, you can allow the user to enter data in specific cells only and restrict the user not to enter or modify anything in other cells.
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, can someone please tell me how I can add formatting rules to a column of cells so that my price is always displayed rounder to the first decimal places eg 10.5 and not 10.46. Thanks in advance!!
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..👏👏
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!!
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 🙏
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 know how to teach. Thanks a million!
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...
your class is excellent and gives adequate opportunity for learners
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 teaching skills are Awwwwwwwsooommmeeee Sir...
Your explanations are great
Your explanation is very clear Sir 👌 thank you so much
Thank u so much for this useful tutorial. And u presenting method is very clear sir. Thanks a lot again...
Tq bro...Ur teaching style is gud..
fantastic learning by pawan sir
Thank you so much...ur explanation is really very nice 👌🏻🙏🏻
Very very nice explanation Sir and thanks a lot.
Sir, at 00:58, why only A5 is selected for comparing with the fixed cell? Highlighted cell can be any from the selected column...
Marvellous video, thank you
YOU ARE THE BEST.
Thank you very much for explaining well.
And like that all of the Conditional Formatting lessons are finished, POGGERS!
Thank You!
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 for excellent knowledge
*Great Dude I need this touch display ...can u suggest where can I purchase this touch display*
@John Porter Bruh...
Very nice outstanding explanation.
Good teacher!
Precise and very useful
I used to brush up my excel by watching his tutorials. I have one doubt. You can also use filter to get this easily
It's very useful to everyone
Great and good presentation 👌
Very good sir😘
How can I gather the data found through the search to the top rows of the spreadsheet, since my excel sheet is very long?
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.
thanq so much brother i like ur videos so cool way you explain
How do i automatically color rows based on even or odd number dates?
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?
Salute u brother, really nice video
U R the best sir
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
Very nice brother. Good
very easy to understand sir
Thank you😊😊😊😊😊
is this advance conditional formatting examples will work in office 10? please reply.
Which type of board you are using ..??
Useful videos
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 can I not highlight whole row when text is striked through
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
Very very sweet and simple way to explain a diffcult thing sir ji
😇😇😇😇
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 we use same on numbers
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
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?
highlight entire row and Highlight Column and Row at same time both examples not working.
woww ji,,,,Super
How can we get excel files in used lesson?
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.
where can i find the excel file that you are using for teaching in you video?
Hello sir. Very good video. Can you please tell which board are you using
So Impressive !
Formula unable to see what you written in condition formatting
REALLY VERY WELL EXPLAINED SIR , PLEASE UPLOAD VIDEOS FOR LARGE DATA SEARCH BOX
you are my super hero
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 got all your concepts but i didn't get how to apply the last one.
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 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
but in the data will be some ex- "nagendra" in A1 to A15 the text will be same but age not same how to solve , plz.... tell me
Hello if 2 condition has to be executed one after other consisting of dates how can it be done
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.
Very Nice , How can i format a part of row (Cells which are being used in formula) by coditional formatting and sumproduct formula. Thanks
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
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
Sorry to say sir ,but you are explaining how to apply formula in a proper way, we are here for formulas only
thank you so much bhai.
Hi, how to say like cell A1 =50 to 60% of A2 then apply a certain color. Please help.
Regards,
Vaidehi
Hi, use this formula on cell A1 when you are creating a conditional formatting rule:
=IF(AND((A1/A2)>0,5; (A1/A2)
How to lock or protect the data of rows or columns? Please
You can protect the sheet. And in property window of cell (CTRL+1), in protection tab , there is an option whether you want to lock the cell or not? By doing this, you can allow the user to enter data in specific cells only and restrict the user not to enter or modify anything in other cells.
how to change the colour when the number is negative into red & when number is positive into blue in the same column.
Please kindly show us the formulas you are entered in the conditional formatting dialog as my own is not formatting. Thanks
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.
sir, iam raghu in this video highlight one column value is not working it is just highlighting the fix column can you plz explain once
THIS IS NOT WORKING HOW CAN I GET YOUR HELP SIR
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
unable to get the results irrespective of using the same formula
to get highlight for entire record 1:48
I Love You
Sir Brilliant
Sir how to highlight name of the candidate if their payment date is suppose before 12/05/2020
Please help sir Or anyone
chettan kollam
Very nice
Hi Sir, please upload a video over conditional formatting with excel VBA code. Thanks!
i like the way you use a big screen
Hello, can someone please tell me how I can add formatting rules to a column of cells so that my price is always displayed rounder to the first decimal places eg 10.5 and not 10.46. Thanks in advance!!
If you want to round your values upward then you can use ceiling.math function in excel.
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
Column selection is not clear. You hv written formula in left side cell to understand but it is not visible.