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.
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.