Now it should highlight the rows where the day is either “Sat” or “Sun”. Now choose the formatting color that you wish to highlight the “Sat” & “Sun” dates. Now we need to highlight the rows wherever the date’s day is “Sat & Sun”, so enter the below formula first. Select the table without headings and click on “Conditional Formatting”, and choose “New Rule”.Ĭhoose the option of “Use a formula to determine which cells to format”. Whenever the weekend comes, we need to highlight those dates, so we use “Conditional Formatting” for auto-highlight these days. Use the TEXT function to convert the date from column B to today’s name. After inserting the column, change the date format to “DDD”. Next to the “Date” column, insert one more column to arrive “Day” name. Now we need to mention the dates involved in the mentioned month, so enter dates from 01 st Jan to 31 st Jan first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |