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.
Conditionally format an entire row based on the date in the first cell of that row
-
- 3StarLounger
- Posts: 310
- Joined: 19 Apr 2010, 16:18
- Location: middle of the state of Washington
-
- 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
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 ...
=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
Hans
-
- 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
Well dagnabit I should have known that, Hans! Thank you. That fixed it!