In the next dialog box, select the menu Use a formula to determine which cell to format. To change the color of the weekends, open the menu Conditional Formatting > New Rule Assume that you have the date table–a calendar without conditional formatting: When you design an automated calendar you don’t need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule.īelow are step-by-step instructions for a few of my favorite conditional formats for dates. These 10 date options generate rules based on the current date. You can select the following date options, ranging from yesterday to next month: Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. To find conditional formatting for dates, go to Get Excel The basics of conditional formatting for dates
0 kommentar(er)
