Conditional Date Formatting

If the value in cell satisfies a user-specified condition, use the Conditional formatting it is possible to allocate this cell (for example, change its background). In this article, go ahead - will highlight the entire table row containing this cell.

Conditional formatting there are data belonging to different months.

Use Conditional formatting to signal the user of MS EXCEL of belonging to a particular date range.

in order to create a calendar for a month, it is enough to write one the array formula.

suppose you have a list of certain events, such as holidays. Find the nearest event, which hasn't happened yet.

using Conditional formatting to highlight the background of cells containing days of the week Saturday and Sunday, red.