To follow along as you read, download a copy of this Excel workbook. After you click the link, you'll find the download button ... Next, in the Conditional Formatting Rules Manager dialog box ...

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 ... button to apply it and close the dialog box.

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details).

You can set Excel to display dates in a variety of ways, no matter how you type in the data. Here's how to find and change date formats in Excel on a Mac or PC. How to change the date format in ...

Note: You may also use other formatting options available within the Replace Format dialogue box ... Next and Replace options. Here’s how: This winds up with how to find and replace text color ...

The X-axis, which is the horizontal axis, on most Excel ... Format Axis window appears. Click on the radio button next to "Specify interval unit," then place your cursor into the small text box ...