00:00Peace be upon you. Welcome to a new stage of the Excel program.
00:04In this stage, we will learn together about a group of commands and settings that are a bit more advanced than the commands we took in the first stage.
00:13We will start together with police coordination.
00:15We previously discussed the normal formatting. How do we change the colors of the empty spaces, the font size, and the data type, etc.?
00:22Now we will do a slightly different format called conditional formatting, which, as its name suggests, depends on a specific condition.
00:30Meaning, what should I say? This is a format for the cell if a certain condition is met.
00:34Ok, if this condition is not met, it will not receive coordination.
00:38Like what, for example, here I have an example that we will work on with a group of random student names and the grades they received.
00:47The student is supposed to get a grade, and for example, I have a sheet with a lot of Excel data.
00:53I need to know which students got, for example, a score of 90%.
01:00Or who are the students who got excellent grades, who are the students who got very good grades, and so on?
01:05How do I do this? Come on, let's see together.
01:08Here, for example, in this column, I have the estimates.
01:11I have to decide on it
01:13I will make a very normal selection or on the entire column from above so that I do not get embarrassed if there is a lot of data
01:19Ok, after I specified them, I have a tab called the main ribbon.
01:25I will find you a police officer
01:26There is a small arrow in it, which means there are still settings inside, not just one thing on the outside.
01:32Ok, I will click on the small arrow and it will show me a group of things.
01:35First of all, the cells are differentiated.
01:38It is written here greater than, less than and equal to
01:41Ok, what is greater than, less than, and equal to?
01:44It makes me differentiate based on the value of the number that is there.
01:49Is it greater than a certain value, less than a certain value, greater than and equal to, etc.
01:54Okay
01:55So I start by pressing and telling him, for example, I want something greater than 90%.
01:59Okay
02:00Here it is bigger than and I will write to it 90% and here it gives me a random number, seventy-two and a half. I will make it ninety.
02:08Okay
02:09I see it automatically before I tell him okay
02:12It started with their work for me in red.
02:14Ok, no, I don't like the color red.
02:16I will start by choosing from here, for example, the green filling, okay?
02:22Ok, I don't like the green filling. I'll see with yellow. Is it not my city except red, yellow, and green, with a difference in the color of the plan or the words inside?
02:30Ok, very nice. I don't like the red, yellow, and green. I want my own colors, depending on how you make me forget the devil himself.
02:38Press
02:39And I started telling him to forget about the special
02:41Okay
02:43I chose the font color I wanted from it.
02:47Here I have all the settings that I make on the line from outside
02:52Okay
02:52If I want to change the type or style of the font, etc.
02:56I don't want to change the style or anything, I just want the fill color
03:00Okay
03:00Cell background color
03:02For example, it is orange in color.
03:06Okay
03:07Okay, if I don't like all these colors, I can tell him additional colors.
03:11And choose from here the exact degree that I want
03:14Okay
03:15I choose based on what makes me comfortable. For example, she chose this amazing color.
03:20And I start to tell him from here I agree and from here again I agree
03:23And I agree
03:25He starts to give me the orange color on the grades that are higher than 90%.
03:30Ok, I want my opinion. I want grades that are less than, for example, 70%.
03:37The second one, be careful. I will leave the first selection or leave the first color, I will not remove it.
03:42Okay
03:43Haji in the coordination of my badges
03:45Okay
03:46I will tell him again that I am a woman who distinguishes between men and women, but sometimes she is younger than him.
03:50Younger than
03:52Less than 70%
03:54I want it to be green, for example.
03:57Ok, I will tell him I agree
04:00Do you see what he did?
04:02Its green color
04:04The orange color will be the main color, meaning that it will apply more than one of the two chevrons together on the same column.
04:10Ok, and as you can see, he applied more than one badge layout to me on the same column.
04:15KIM Institute
04:16What happened down here?
04:18What happened is that the empty cell, Lil 1, turned all of it green.
04:22Ok, I didn't divorce you like this, I want you like this
04:24I want the cell that has orkombos in it
04:28Tighten the cell that has orkombos in it
04:29Ok, very nice
04:32When I specify the cell that contains orkombas
04:34It is printed on it, okay, from the percentage of the cell under the air, why did they stay there anyway?
04:37Even though I will never cl
04:39It is more appropriate to expel the value of the cell that Maryam has data for, which is 0.
04:43If it is zero, it is less than seventy.
04:45So he will start to print on it the second condition that he is less than him
04:51Very beautiful
04:52I'll start with one of the second
04:55I have the police coordination
04:56Of course, above, as I have, bigger and smaller than it
04:59I have between and equal to the text included
05:02Okay, as for the duplicate date.
05:04What is the repeated history?
05:05Because I have a start date, for example.
05:07Or should we assume here?
05:08For example 23
05:10seven thousand twenty-two
05:13Okay
05:14Here is any other date
05:17Seven, for example, eight thousand two hundred and twenty-two
05:20And here again
05:2123 seven thousand twenty-two
05:25I have this, the date is repeated
05:27I want you to specify the duplicate date for me.
05:29I want to specify
05:31I will tell him about the police coordination
05:33Duplicate date cell marking rules
05:36Okay
05:37Here he gives me a lot of choices.
05:40yesterday, today and tomorrow
05:42In the last seven days
05:43And last week
05:44And many other things
05:46For example, I can tell him today's date.
05:50Okay
05:51Today is something completely different, of course.
05:53I need to change
05:54It remains a yellow text
05:57I tell him to leave
05:58Of course, this is the current time when he will not do anything
06:00I finally let it be today's date
06:02nineteen
06:04two thousand twenty-two
06:06Do you see the first history material today?
06:09He started to change her
06:11Okay, here I will also write nineteen
06:13two thousand twenty-two
06:15It seems to be determined.
06:17Ok, I'll come back again, police coordination
06:19And he tells him a repeated history
06:21Leave it like this
06:22this week
06:24And agree
06:26You see, he will do it on the same dates.
06:28Because today is not the same this week
06:32Okay?
06:32I change the color to green
06:34I stay here, I have the rules. The beginning of discrimination is in many things.
06:39Can I use it?
06:40For example, duplicate values are possible.
06:42Here it is
06:44I will go back to her and tell him
06:46Rules for distinguishing duplicate values
06:49Can I choose that the interest values are what will be tomorrow?
06:54Take a color, for example, yellow
06:56It remains the same as what I did in the first column, that I used more than one conditional formatting rule on the same column.
07:05So we have taken the first thing in the easy and simple police coordination
07:08Asthma is found
