 In this turning video, we're going to look at conditional form-marking to form-mark by some text, in this case the product category, and then sorting by color. So first I'm going to highlight the products in the product category. Okay, conditional form-marking, how to tell a rule. I only want to give an example of text that contains, we're going to say we're doing well in machine products. So we're going to say machine, and we're going to say in color category, they're doing well first. We're going to go with a green color. So I'm going to say they're doing really well first. So we're going to color code them. I'm going to go back to the conditional form-marking, and let's tell a rule. That's the contains in this time on S24. Last one, we're going to say excessively red. So we're going to start typing a little bit. You get what we want. You can see that the type of everything. Now I'm going to sort by color. I'm going to highlight all the head-ins. Then highlight the data. I think the actual control is shifting down a little. Do this, or highlight them. Now I'm going to go to the data tab. Sort the sort by color category. Not on cell values, but cell color. We're going to take a traffic light, so red on top. Add a level for the category again. Cell color again. And I want green on bottom. With three colors, I can form a wave looking. So we're trying to form a top effect in this case, where the amber green. And this will do it. Okay. Now we've sorted all the reds. All the amber, all the greens. We now know where we're going. Well, not so well, and we're going to need it. So this completes the training video. We're going to start by using conditional formatting with packs. And then color in the information. And then we also looked at sorting the information via the data sort. And in this case, we needed a sort by two levels. And we sorted by cell color.