Conditionally format an entire row based on the date in the first cell of that row

MelanieB
3StarLounger
Posts: 310
Joined: 19 Apr 2010, 16:18
Location: middle of the state of Washington

Conditionally format an entire row based on the date in the first cell of that row

Post by MelanieB »

How can I create a cf rule that will format (fill color) an entire row if the first cell is Monday (yellow), Tues (green), Wed (Orange), etc.
I can't seem to get the whole row to format.. just the dated cell.

I'm using the formula =weekday(a1)=1 formatted to yellow, then another rule for each day of the week and I set the Applies To as =$A$2:$D$115. Then I tried using the table name (TblTime) in the Applies to...

But, like I said, it's not filling in the whole row.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditionally format an entire row based on the date in the first cell of that row

Post by HansV »

If you want the rule to apply to multiple columns, use formulas such as

=WEEKDAY($A1)=1

The $ before the column letter makes the formula refer to column A whether the cell to be formatted is in column A or B or C or ...
Best wishes,
Hans

MelanieB
3StarLounger
Posts: 310
Joined: 19 Apr 2010, 16:18
Location: middle of the state of Washington

Re: Conditionally format an entire row based on the date in the first cell of that row

Post by MelanieB »

Well dagnabit I should have known that, Hans! Thank you. That fixed it!