Using Conditional Formatting in Microsoft Excel

Have you ever had a spreadsheet that you’d like to apply formatting, such as highlighting a row, if a certain value was within a particular range? It’s not that difficult to do. Below, I’ll walk through doing this in Microsoft Excel 2003 and again in Microsoft Excel 2010. Microsoft Excel 2010 adds additional features such as including icons in the cells. Conditional Formatting in Microsoft Excel 2003 Let’s assume we have a table that looks like the following: We may want to highlight anything in red that is past due at least 60 days. If today’s date is June 5th, … Continue reading Using Conditional Formatting in Microsoft Excel