 In this video, we're going to look at how to apply conditional formatting to parts of an Excel spreadsheet. So here I want basic salary formatted and the example I'm going to give you is anything less than 20,000. We're going to turn to green for the basic salary. So I'm going to highlight the basic salary area. And now we're going to go to conditional formatting, which happens to be in the home tab. In this example, I'm going to use highlight cell rules. And I'm going to say anything less than and 20,000. So I'm going to type in the value of 20,000. And I'm going to format that with drop down arrow, custom format. And I'm going to choose green in this case. So fill, green, OK. And OK once more. So we can now see that the values which are less than 20,000 happen to be green. So this is how you would apply conditional formatting to a selected range of information. In this example, we used highlight cell rules, but there are multiple other rules you could also go to.