Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.