In our example, we will apply the conditional formatting on the selling price as shown in figure 1.1. The first step is to select the cell or range of cells for which conditional formatting needs to be applied. With this example we will see how to apply conditional formatting ->Greater than. We have different product names, product id and selling price. The following example will show how to apply conditional formatting to get cells highlighted with values greater than. In this article, we will dig in about how to use “Greater than” under the category Highlight cell rule. Under excel conditional formatting we have many categories to format our data or range of the cell. ![]() Conditional formatting easily spots trend and pattern in your data using bars, colors and the icons to visually highlight the important values. It helps in distinguishing among the data with different colors and makes data in the spreadsheet look easier to understand. Conditional formatting helps the user to highlight a cell or range of cells according to the criteria we supplied.
0 Comments
Leave a Reply. |