A more recent version of the Excel course is available here: Excel Course

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.

cf saturdays sundays excel conditional formatting examples3

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

display cf weekends excel conditional formatting examples3

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.

cf gridlines excel conditional formatting examples3

The results:

display cf gridlines excel conditional formatting examples3

Source file: cf8.xlsx

9. Shade the Last Value in a Column

CF will find the last value in column C using the COUNTA.

cf last value column excel conditional formatting examples3

The results:

display cf last value column excel conditional formatting examples3

Source file: cf9.xlsx

10. Shade Today's Date and Previous Dates

CF uses the today's date function (TODAY) for this test.

cf dates excel conditional formatting examples3

The results:

display cf dates excel conditional formatting examples3

Source file: cf10.xlsx