Excel for the web supports rules in the conditional format feature, but you are limited to the formats you can choose. How to group the data in Excel Because we’re formatting groups, the data ...

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.