WEEKDAY - Highlight Row Gray if Sunday

[Liberty42]

I just want to gray out SUNDAY rows.

As an example, Column A contains the year, column B contains the month, column C contains the day.

Visible, usable data are in columns D through I.

=WEEKDAY(DATE(A4,B4,C4))=1

APPLIES TO ONE ROW: $D$4:$I$4 - doesn't work.
APPLIES TO A SUNDAY ROW: $D$8:$I$8 - doesn't work.
APPLIES TO ENTIRE AREA: $D$4:$I:$35 - doesn't work.

I give up.


I wanted to upload an attachment but I got a malware warning!!????!!!???!!!

[Tony Valko]

Let's assume you want to format the range D4:I35.


Select the ENTIRE range D4:I35 starting from cell D4.
Cell D4 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=WEEKDAY(DATE($A4,$B4,$C4))=1

Click the Format button
Select the desired style(s)
OK out