Try these methods for more uses of conditional formatting. For example, you can use conditional formatting to compare lists and find discrepancies. Once you understand the basics of conditional formatting, you can experiment with various criteria and formatting styles. You will see cells meeting your criteria highlighted in the formatting you chose. Enter any conditions into the fields, and select a formatting option. Learn over 20 different ways to use conditional formatting in Excel to do things like add color scales for data analysis, add data bars for in-cell charts and progress bars, and create a gantt chart.
![conditional formatting excel 2016 how to conditional formatting excel 2016 how to](https://fiveminutelessons.com/files/excel-conditional-formatting-toolbar-options-list.png)
If you data contains a lot of numbers, try Greater Than and enter a value that is less than a number on your sheet. If you’re stuck, try Text That Contains if your data has a lot of text, and include something you know is in multiple cells (like the word “yes”).Choose one of the options in Highlight Cells Rules or Top/Bottom Rules.In the Home tab, click Conditional Formatting in the Styles area.Select which cells or rows/columns you want to format.You can create your own conditional formatting rules, but to understand the tool, it’s easiest to first play with the pre-made rules that come with all modern versions of Excel.
![conditional formatting excel 2016 how to conditional formatting excel 2016 how to](https://community.qlik.com/legacyfs/online/183524_2.png)
Applying conditional formatting will change the cell color, font, and border depending on your criteria. It can come in handy when you need to identify certain criteria at a glance.įor example, you may want to see cells that contain duplicate values, or see values that fall in the top 10% of your range. Conditional formatting is an Excel feature that allows you to do just what it sounds like: apply different formatting to data depending on various conditions.