the color in which return value will be highlighted in Light Red Fill. the return highlighted value will be those numbers which is greater than 300 and the formatting style i.e. Have a look at the figure1.3 fora clear understanding. The color can be customized one also, to customize you have to select a custom format. We can also choose a color for highlighting the cell.
As we are working on format Greater than, the return value will be the highlighted cell which is greater than the value we supplied in the dialogue box. Select Conditional formatting using the keyboard:Ĭonditional Formatting > Highlight Cell Rule > Greater than as shown in the figure1.2 figure 1.2Īfter selecting the Greater than option, a dialogue box will pop up which asks for a value. As in this article, we are looking into greater than, we will stick to greater than option under highlighted cell rule. You will not get the return highlighted cell unless a nonblank cell is selected.Īfter selecting the range of cells, select conditional formatting in the ribbon column. 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 kommentar(er)
