Excel Course: Conditional Formatting (examples 7 to 10)
7. Format Weekends
The WEEKDAY function determines whether the date that appears here falls on a Saturday or Sunday.

In this case, all the cells being tested are dates whose display settings have been edited (via "Format Cell").

Source file: cf7.xlsx
8. Automatically Adding Gridlines To Cells
CF will determine whether there are any values in the cells in column B, and if there are, the whole row will be formatted.

The results:

Source file: cf8.xlsx
9. Shade the Last Value in a Column
CF will find the last value in column C using the COUNTA.

The results:

Source file: cf9.xlsx
10. Shade Today's Date and Previous Dates
CF uses the today's date function (TODAY) for this test.

The results:

Source file: cf10.xlsx