Excel Tip: Conditional Formatting

Conditional Formatting

Microsoft has a great function in Excel for conditional formatting that is very useful for visual purposes. It is the ability to assign a unique format to a group of cells. I find this function helpful when working with large selections of data within a spreadsheet. This allows you to instantly recognize values that are greater than, less than, equal to, or whatever you select. This is especially useful when you want to see something, but not necessarily sort it by the specific value of choice. Hightlight by selecting the range of cells holding your criteria.

In this example, we want to add the condition to format all data greater than the value of 100.

Choose: Home → Conditional Formatting → Highlight Cell Rules → Greater Than. Enter the value, in this case, 100. Hit Enter.

If you decide that you need to change the select function or style, you can clear the conditions you entered. Go back to conditional formatting, scroll to the bottom and select: Clear Rules → Clear Rules From Selected Cells.

As you view the options behind this function, I think you will find it very useful.

There you have it. I hope you found this Excel formula useful with your next Excel spreadsheet project.

, , , , ,

Comments are closed.

Powered by WordPress. Designed by Woo Themes