 In this training video we're going to look at conditional formatting to format by some text, in this case product category, and then sorting by color. So we're first going to highlight the products in the product category. We're going to go to conditional formatting and highlight cell rules. And we want in this example text that contains. So 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 color that green. So they doing well for us. I'm going to go with a green fill. Go. Now we're going to say the bowl. We're going to say we're going to be they doing visually well for us. So we're going to color code them orange. So back to the conditional formatting, highlight cell rules, text that contains. And this time when I say contains bowl. I'm going to make that an orange. You can see what's happening so far. Click OK. Last one, we're going to say accessories are going to be red. We're not doing so well in these. So as soon as you start typing a little bit, we get them when we want. So I'll just leave it as the type it is now. You can see that the type of everything. I'm going to type the latter with a ready color. We can now see what's happened. I'm going to click OK. Now I'm going to sort by color. I'm going to highlight all the headings. Then highlight the data. So I tend to use control shift and down arrow. Do this. So I highlight them. Then control shift down arrow to highlight all the information. Now I'm going to go to the data tab. Sort. Sort by product category. Not on cell values, but cell color. I want to look like a traffic light. So we're on top at a level. Product category again. Cell color again. And I want green on bottom. So with three colors, I can form a way of looking. So we're trying to form a traffic light. In this case, red, amber, green. And this will do it. Click OK. So now I've sorted all the reds, all the ambers, all the greens. So we now know where we're doing well, not so well, and where the improvements are needed. So this completes the training video on using conditional formatting with text and then coloring the information. And then we also looked at sorting the information via the data sort. And in this case, we needed to sort by two levels and we sorted by cell color.