When is conditional formatting in excel used

Save my name, email, and website in this browser for the next time I comment. Top Menu. Comparisons You can also build rules or conditions to compare values. Formatting Your level of creativity is the only limitation to the things you can do to build visual cues in your spreadsheet. You can: change color cells highlight entire rows based on cell values in the row insert icons change fonts format alternating row bands and more! Categories: Microsoft Excel.

About The Author. James Palic. Related Posts. Top 10 Excel Functions For February 4, Leave a Reply Cancel reply Your email address will not be published.

Ready to take your Excel knowledge to the next level? Check out SkillPath's variety of Microsoft Excel online training opportunities. On some Excel sheets, you may want a visual guide to help you better see the variations in your data. A two-color scale can be used to compare a range of cells using different shades of color to represent different values. In a red and yellow color scale, for example, you can specify that higher value cells have a shades of red and lower value cells will have shades of yellow.

In a PivotTable report, you can change the method of scoping for fields in the Values area using the Formatting Options button next to a PivotTable field that with conditional formatting.

When you are using numbers, you may want to use an icon set to annotate and classify data. The data will be categorized in three to five areas and separated by a threshold value. Each icon used will represents a range of values. In the arrows icon set, the green up arrow will be your highest values, the yellow sideways arrow will be mid-range values, and the red down arrow will be your lower values.

SkillPath may use cookies to help us personalize your browsing experience, eliminate the need to fill out forms multiple times and enhance your Web site experience and the ease in which we can interact with you and your past activity and purchases.

We love meeting people like you who make professional development a top priority. The great thing about conditional formatting is that it lets you specify the condition or criteria for formatting in a multitude of ways.

You can use it to format:. In this tutorial, we will be applying conditional formatting using a formula. This means that Excel will decide which cells to format based on the result of a formula. So, you can have an OR function with the following syntax:.