 In this training video, we're going to look at the top and bottom conditional formatting feature. So I will display, for example, sales quantity, the top five sales quantities in green and the bottom five in red. So I'm going to highlight all the date of sales quantity. I'm going to go to conditional formatting, top and bottom. So you can do, this is the top 10 items, but it doesn't have to be, it can be the top five. So I'm going to go top 10. I don't want 10. I can come down to five. And I want that to be green. And I want to do the green fill. Pick OK. And then the bottom five, just need the data highlighted, conditional formatting, top and bottom, bottom 10 items. I'm going to change to five. And this one I want red. So quite simple when you get used to the process behind it. And there you go. Okay. So this now shows the sales quantities, which are the top five and which are the bottom five in red. And this completes the training video on conditional formatting using the top and bottom items feature. And we changed 10 items to five items for both green and red. If you enjoyed this video, make sure you like and subscribe to our channel. Hope to see you for the next tutorial and thanks for watching.