00:00Peace be upon you, and I welcome you again to complete the conditional coordination in Excel.
00:06We learned together in the previous lecture or in the previous video
00:10How do we specify or format duplicate dates?
00:17Whether the date is today's date, yesterday's date, or any of the options available in the program
00:23We also know how we apply more than one conditional formatting to the same column for our values, whether they are greater than or less than any value.
00:32And so on
00:33Okay, now we will continue together normally. In this video, we will learn how to cancel the formats that we made.
00:41How can we apply more formats specific to the same values? We create icons that distinguish these values, whether they are greater than or less than a certain value.
00:52We know other formats that we can use for the data in a hierarchical way or in a way that makes the data look like we are seeing each other.
01:03First of all, I have the same thing and the same file that we worked on last time.
01:08I want to remove the formats that I had made so that I can start working on new formats, so I will start by determining if
01:15On this cell, I just have to specify it and I tell him to format my badge and scan it for me.
01:21For the rules, here it gives me two options: either I delete it from the selected cell that I
01:27What I am selecting or defining or from the entire paper, I mean
01:31He will delete it from here and there and from any other format. I have done it perfectly, so I will tell him.
01:36For example, erase the entire paper for me. You see, the paper came back white with me.
01:41As it was nice first, we start by making formats according to our data
01:48I have some icons with me, so I tell him to coordinate my badge and make groups with them
01:54Icons Did you give me a set of icons? Are these icons random? No, they are not random.
02:00The largest one takes a certain color and the smallest one takes a different color, and so on. That is, here when I stopped
02:08On red, yellow and green, I find that green has the highest values, red has the lowest values and yellow
02:16Between this and that, it's fine. Okay, I have four colors here.
02:23Outside, he starts giving me the red one, the higher one, and the gray one, which is a little lower.
02:28The lower the bimek the more and the red the least at all. Here are the columns that express
02:34Data. It depends on what we need for our work.
02:40Except for the date media. Everyone chooses the icons they like. Okay, I have them.
02:50Here are other color scales, gradations between colors according to the highest values.
02:55We notice here something that here the gradation is green, yellow, and then color scales.
03:01Red. I find that it is not exactly attached to my column. And that
03:06What does it mean? It means that it depends on the value or the number itself that is present.
03:10It starts with the color, not the shades coming down with me.
03:14From top to bottom in the same way we saw. Okay? Okay, I'll come back here.
03:18The second one is to cancel this tissue. It's made of specific cells. I have it.
03:24Here are ten data. It will also be useful to me, I mean an area of color.
03:30Depending on the value I have, if we take care here, the water
03:34He took the whole area, seventy less. Forty-five less than it and crutched it. Okay, I'll go back.
03:41I have deleted it from the rules. Specific friends. I have a tape here.
03:49We left the data. I have the first and last value and rules.
03:53I have the first ten and the first ten percent and so on. This is the first ten and the first ten percent.
03:57Monday gave me the same result. Right? And the last ten and the last ten percent also gave me the same result.
04:03What do you mean? The first ten percent. If I, for example, made up that she
04:06Students' grades. The first ten means we will tell the first ten who brought
04:12Final grades. He will take it with us 100%. Now, after nine and nine in...
04:18He'll take the water. And so on until he reaches the top ten. Okay? In that way.
04:26For us. Of course, I can make it the first four values, for example. It doesn't have to be the first ten.
04:32Can I change it to green, for example? Okay? I tell him OK. And I come back again. Like in
04:40I have the top ten, I have the last ten, and I have above average. Above average if
04:44For example, let's assume that the grade is out of 100, so the average is 50. Above average, we'll start from
04:50Fifty-one, fifty-two, and so on until we reach the hundred every time
04:54Average. It is also possible for me to give it a color other than yellow. That is, I will start with...
05:02I'll take what I want. I'll tell him, "This is the end of the matter." Okay? I have it.
05:10Below average, we'll reverse the situation. I have additional criteria.
05:14If I sell, if I hide my own dates, I will start by telling him
05:18For example, sorting only the highest or lowest ranked values. Choose, for example:
05:25Which is the lowest, which is the lowest. That is, the last value, for example, the last
05:31Three values. I start to work on it. It takes the color.
05:38Okay? I'll make my line white. And I'll tell him
05:48OK. Mina also agrees. So he starts to apply what I tell him is less.
05:55Three values. It takes the color brown or purple. And the words that
06:01There was a white line in it. Let's do it again.
06:04We set a rule. I'll tell him, for example. Here are additional rules. By the way, rules.
06:10You will find an additional feature in any of these things. There is a possibility that we
06:14We add additional rules. Okay? I mean, I don't have to get them from anything.
06:18As I please. I will tell him, for example, unique or repeated values. And I will choose the values for him.
06:23Repeated. Okay? Its format is like the line, for example.
06:30Mine. Its color is like this. And the packaging is like this. I agree. Me too.
06:40Ok. He starts by giving her the color that I chose, which is the color.
06:47This is travel. I have to remove the rules whenever I want to erase the rules.
06:54I start adding new rules whether you are from additional rules
06:58Here or new rules here. The two of one. Okay? I'll start that I
07:03Choose what I want. Okay? Then choose settings.
07:09Its own and I tell him the format. Okay? I choose the format for the environment and the font.
07:14And the limits, if I want limits. I mean, the matter is in our hands, we can do that.
07:20Shall we put what we want, okay? And after I put it, I tell him
07:24Ok, of course. Here, because I did not enter any value at all. I am here, it is a coordination machine.
07:35The coordination that I mentioned. Of course, it is equal to Musla. Musla, yes, yes, I agree.
07:38Those who agree. Those who agree. Those who have 88 will take the format that I evaluate.
07:40And he takes the arrangement that I told him about
07:43Of course, if I don't format it, it will be left as it is in white.
07:46An easy and simple topic that just needs us to hit on it
07:50Come on, try it
Comments