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

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

Microsoft Excel’s RANK.EQ () function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ () with a conditional formatting rule to highlight ...

Excel gives you complete control over the conditional formatting in your workbook, allowing you to customize the criteria, style and color.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

Conditional formatting in Excel offers a simple yet powerful way to elevate your project management. It transforms static spreadsheets into dynamic tools that provide real-time insights into ...

Open an Excel workbook and select the Profit column. Select Conditional Formatting > Highlight Cells Rules > Greater than. Enter $5000, select Green Fill with Dark Green Text and click OK.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.