Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

What Is Conditional Formatting and How Is It Useful Conditional formatting in Excel is a feature that allows you to automatically apply specific formatting to cells based on their content. By ...

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

I think the biggest problem here is that the first column (courses) doesn't contain unique values, so any VLOOKUP using it will only return the first value in that column.

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.