Chapter 5: Formatting Worksheets
55
Identifying weekend days
Excel provides a number of conditional formatting rules that deal with dates, but it doesn’t
let you identify dates that fall on a weekend. Use this formula to identify weekend dates:
=OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1)This formula assumes that a range is selected and that cell A1 is the active cell.
Highlighting a row based on a value
Figure 5.18 shows a worksheet that contains a conditional formula in the range A3:G28.
If a name entered in cell B1 is found in the first column, the entire row for that name is
highlighted.
FIGURE 5.18
Highlighting a row, based on a matching name
The conditional formatting formula is
=$A3=$B$1