Formatting values to categorize them or get our attention is a common practice in Microsoft Excel. Fortunately, a conditional formatting rule usually does the trick, and the feature is easy to use.

For deeper dives, check out my earlier articles on creating relational tables and creating relational databases. How to create an Excel table 1. First, enter the field names in the columns across ...

For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.