Accept conditional formatting, close dialog.Pick/edit the style with the background to suit.Next to the Formula dropdown selector, enter the formula: WEEKDAY(A1 2) Select from the dropdown list in the formatting dialog box, Formula.Select the first cell in the list of dates ( A1).The following steps will succeed in reproducing finished product: Conditional formatting documentation here.Īs explained by these steps can be consolidated by using a conditional formatting Formula from the dropdown list. Then, apply Conditional Formatting on the new column, every value less than or equal to 5, have that be your weekday color, add another style and condition for greater than 5, that will be your weekend color. The documentation for the function is here. In a separate column, run the formula =WEEKDAY(A1 2).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |