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