Welcome back.
So in this lecture we will learn about conditional formatting in part what we like.
So one of the good news here is that in the mid 2000 it's in a bit of power.
They have released a very good feature in conditional formatting so I will be covering that feature
of conditional formatting in this tutorial as well.
So conditional formatting allow you to format the cells of any particular column on the basis of any
condition which you apply.
So let's see how conditional formatting works in power.
So I have this sample people created here of my customer name and their sales is in front of them.
So I've gone to do a conditional formatting apply conditional formatting on the state's number.
So for that if I left to go to my Pharmac then I left click on the conditional formatting.
Once you do that you will see these options go background color scales and color skills so you can apply
this from the drop down all the columns which you have in the table you can apply this formatting on
any one of them to pull up the platform or do you want my sense of when I click on see is these three
options to come up from color skills from the dubbers.
So because this is our new medical column so I can creep up ours here.
So when they click on on it they automatically cleared the bar's visit no value so this one is having
very I see elsewhere.
So it is showing a very high but then this is almost negligible.
This is our normal bar.
So this will create the bar venues like this we can simply dump bag on collars as well.
So right now it is still dark.
Formatting is done by the different venues we can of course change it by our own format by our own conditions.
So to do that once you have a click on the door on the back of the scale you have to go through advanced
controls.
Now here's the deal.
After you have click on advanced control you'll see this pop up.
So ideally before mid 2000 it didn't you just have these particular features up here which is the format
blank values.
And I met him on the maximum values suppose I can get the minimum value as any number so value as well
it can be anything I can apply it here or I can turn it to any noise when you do that.
And I just when you do this color.
So this is not the first color which has been applied here.
I can apply any number here so my noise value will be anything like.
Let's see.
I do apply on any particular number.
Suppose I did the number from here which is 16 560.
I mean any number you can take here so you can apply any number here.
I'll just not show you this because this isn't that important.
You can apply any number when you click on divulging you will have a middle class as well.
Right to win.
Now when you click OK you're going to have I'd be there dollar as well.
So let me show you I think of all this silently going click went OK.
There you go.
Once I've done that you can see some light right here in my data bars.
Now here is the important feature in conditional formatting so this is all you can do with some minimum
demand.
You can create a gradient of colors.
Now suppose you have dealt the second method of conditional formatting is colored by it.
So why not check it here.
I can apply the first condition to my formatting.
So this first condition will only be applied to the numbers up here.
So I am playing on the since column here so.
So first if my sis values greater than or equal to 20000 I want to turn the someone like this I lead
a black and name one more year.
Suppose if my sis when value is greater than
let's say greater than I make this less than 50000.
And if my vote values greater than 50000
let's start to zero.
And so if my values greater than 50000 I'll make it bloom.
So if it is good then 20 and less than 50000 It should show this club if it is greater than 50 it should
show this color so I can apply these rules here.
When I click on OK my formatting will be done.
So as you can see I applied only to only two conditions so some problems have been left blank.
But you can try working on this and you can apply as many conditions as you want.
I want to just show you the demo.
So how would this thing work.
So all the values from 20 to 50 have been don't do that and greater than 50000 have been torn to part
of it to apply the conditional formatting here is to format cells with color based on any venue.
So suppose what I want to color this particular my color of my customer name is going to see it's kind
of.
So before mid-2000 did this feature was not available to apply conditional formatting on any color based
on any of columns.
You now so we can't do that.
This would be this is very very useful.
So Paul I want to apply conditional formatting on customer name.
I click on background and then I will apply to this allows me to apply color because my name is issuing
what I have zagged right here.
So I want to apply kind of color based on what I can select as many in any column from here.
So let me show you how this thing works.
So I had a particular major He had a flag Major as you can see it shows that if my sales value is greater
than 50000 then the value should be over if it is not and the value should be zero.
So if I take it in my table you will see what this really means.
So all these values fossicking unthawed is less than 50000 so they are ZERO these values and then 50000.
So the flag is showing 1 1 1 0 1 0 0.
So this is all this flag has been applied for.
Now I will use it in my conditional formatting that see I want the customer names on customer name I
have to apply conditional formatting.
Now the condition here is if my sales flag is run then the customer name should be highlighted to any
particular color like blue and if it is 0 then it should be red.
So I have this is flat column here.
All I want to do is on the basis of this column I have to apply for a day on this.
I started on I collect based on the I would choose my column which is says flag.
That said to the left.
This has been done color is red and blue.
So when I click on OK there you go.
This is how this works so all my one word Luzier are down to you.
And so the values are there.
So in this way we can apply this conditional formatting on text columns as well which was not available
previously if we have all done this.
But if you're if you're doing this for the first time then you can try working on this feature which
is quite useful.
So this is how you can apply conditional formatting.
So it's quite handy for different fields of blank conditional formatting and power b.a.
I want to do.
Please please try all of these different types of formatting features because they will be.
They would be very very useful when you'll work on this.
And if you find any kind of doubt just simply ask me and put it in look me a section if along with the
query I'll be happy to help you with all of your all of your queries.
So keep on working and we'll meet in the next lecture.
Thank you.