Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and identify variances of cells' values with a quick glance.
At the same time, Conditional Formatting is often deemed as one of the most intricate and obscure Excel functions, especially by beginners. If you feel intimidated by this feature too, please don't! In fact, conditional formatting in Excel is very straightforward and easy to use, and you will make sure of this in just 5 minutes when you have finished reading this short tutorial.
Answer:
These steps will help you create a new conditional format. My explanation will be done using Microsoft Excel 2013. Same steps apply for a higher version of Microsoft Excel
Explanation:
Step # 1 -- Name the data range. To start off the process, select the first cell of the data in your spreadsheet and press the " Shift " key and click the last cell in the column containing your data you wish to apply the conditional formatting on. The values will be selected. Now go to the "name" bar and type in the name of the range.
Step # 2 -- Select a Color Scale. Once you have selected the data, click on the "conditional formatting" button under the "styles" group in the "home" tab. Go to the “Color Scales”, in the pull menu select the fourth color in the bottom row to apply the Yellow fill.
Step # 3 -- Make a new rule. You can also make new rules by selecting the "new rule" option from the conditional formatting drop-down menu. Once done, a new box will appear where you can select the rule type, format the style and perform other such actions. In the “Select a Rule Type” click “Format only values that are above or below average” and select “above” in the “Format Values that are” field and click the “format button.
Step # 4 -- Apply the Highlight Cells Rule. Here, you can apply the "highlight cells rules" option. Once you click on this, a number of options will appear. Select the "greater than" rule and input a conditional value of 98%. All values above this conditional value will be highlighted since the condition is of "greater than". Select “bold” under “font style” and click the OK button twice.
