MS Excel - Advanced Conditional Formatting
MS Excel - Advanced Conditional Formatting
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
MS Excel - Advanced Conditional Formatting
Watch More Videos at:
www.tutorialspoint.com/videot...
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Пікірлер: 195
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..👏👏
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!
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 KZread.. Hats off!!
I have looked for this to many videos, but eventually with you I learnt and become able to apply it. thank you.
You know how to teach. Thanks a million!
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
Thank u so much for this useful tutorial. And u presenting method is very clear sir. Thanks a lot again...
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
Marvellous video, thank you
this my 80th video from your playlist , will watch all 101. You are really great Mr Lalwani.
@PavanLalwani
5 жыл бұрын
Thanks Lavender
Tq bro...Ur teaching style is gud..
And like that all of the Conditional Formatting lessons are finished, POGGERS! Thank You!
Your explanation is very clear Sir 👌 thank you so much
Thank you so much...ur explanation is really very nice 👌🏻🙏🏻
your class is excellent and gives adequate opportunity for learners
Your teaching skills are Awwwwwwwsooommmeeee Sir... Your explanations are great
thanq so much brother i like ur videos so cool way you explain
Very good sir😘
Thank you very much for explaining well.
Thank you for excellent knowledge
Very nice outstanding explanation.
fantastic learning by pawan sir
YOU ARE THE BEST.
Salute u brother, really nice video
*Great Dude I need this touch display ...can u suggest where can I purchase this touch display*
@abrarahmad6370
3 жыл бұрын
@John Porter Bruh...
Thank you for teach me a tough thing
Very very nice explanation Sir and thanks a lot.
Great and good presentation 👌
U R the best sir
REALLY VERY WELL EXPLAINED SIR , PLEASE UPLOAD VIDEOS FOR LARGE DATA SEARCH BOX
It's very useful to everyone
So Impressive !
Very very sweet and simple way to explain a diffcult thing sir ji 😇😇😇😇
I Love You Sir Brilliant
Thanks Sir
Precise and very useful
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.
Good teacher!
woww ji,,,,Super
you are my super hero
Very nice brother. Good
Useful videos
thank you so much bhai.
We would very much appreciate it if you would kindly show us the formulas you are entering in the conditional formatting dialog boxes.
@miguelma3237
5 жыл бұрын
zoom in
@SuperCornjulio
4 жыл бұрын
lazy mofos......
@muhammadimrankhan7291
2 жыл бұрын
These are auto formulas by default in excel, you only need to select option.
Thank you boss
Thank you uuuuuuuu so much
i like the way you use a big screen
Nice video however we can expand this part as it covers many more in conditional formating
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?
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
i like this,,,very2 nice
thank you so much
Thank you😊😊😊😊😊
I used to brush up my excel by watching his tutorials. I have one doubt. You can also use filter to get this easily
Very nice
thanks bro
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
Hello sir. Very good video. Can you please tell which board are you using
highlight entire row and Highlight Column and Row at same time both examples not working.
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
great
Can you please explain, formatting rows or columns, with partial text
where can i find the excel file that you are using for teaching in you video?
Hello sir, I need a help for conditional formatting.. could u plz
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..
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 ..??
Thank you
Sir, at 00:58, why only A5 is selected for comparing with the fixed cell? Highlighted cell can be any from the selected column...
Good...
to get highlight for entire record 1:48
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.
Hello if 2 condition has to be executed one after other consisting of dates how can it be done
Yea, but can you turn conditional formatting on and off tho?
How can I gather the data found through the search to the top rows of the spreadsheet, since my excel sheet is very long?
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
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..
@SuperCornjulio
4 жыл бұрын
anjali goorha coz his actually the real father...
is this advance conditional formatting examples will work in office 10? please reply.
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
Hi Sir, please upload a video over conditional formatting with excel VBA code. Thanks!
you are handsome and you are speaking so good in English
Nice
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
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.
Thanks for your good plan teacher I could request you to teach me barcode full course
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
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
3 жыл бұрын
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.
@kushjhingan6149
3 жыл бұрын
@@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?
you can zoom the tool box used
Please kindly show us the formulas you are entered in the conditional formatting dialog as my own is not formatting. Thanks
How do i automatically color rows based on even or odd number dates?
Sorry to say sir ,but you are explaining how to apply formula in a proper way, we are here for formulas only
🙏🙏
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!!
@TekhXpert
3 жыл бұрын
If you want to round your values upward then you can use ceiling.math function in excel.
Can we use same on numbers
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.
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