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

Download PDF files of this course