 Select the cells where you want to apply a style. Being in the Home tab, click on the Conditional Formatting button here. Now click on the Highlight Cell Rules. Let's choose the first option by clicking on the greater than. A new window is opened. Get ready to say goodbye to your old case because Casemate has a better one. See the link in the description below. Here you need to set up two things. The number that marks the point after which the style appears and to the style you want to apply. In the first field, I will type 400. That means that the rule will apply to the cells with numbers that are greater than 400. Let's select the style we want to apply for this rule. Of the options available, choose the one you want or create a custom style. I will select the green fill with dark green textile. Then click OK and that's it. As you can see, the new style is applied just in the cells where the rule applied. If you change or write new data, the rule will still apply unless you change the rule. Don't miss any of our videos by subscribing to our Burn to Learn channel.