2] User-defined conditional formatting date rules with Dates Apart from a set of pre-defined rules, Excel also provides the option to customize these rules based on user requirements.

Figure C Set the following conditional formatting options in Excel. As you can see in Figure D, the new rule highlights the weekend dates. You can easily check, by looking for TRUE in column D.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...