When Use Metadata Formatting option is enabled, any column-based formatting will be replaced with the formatting information coming from your workbook. This works on the cell level, meaning that you can set a different formatting for every individual cell. When this option is enabled, the system will also be able to detect any cells containing formulas, and disable them automatically.

Note that you must also enable the trigger calculations option along with metadata formatting, because the formatting properties of each cell is evaluated during run-time calculations.

Even though it can automate the formatting process, the Use Metadata Formatting feature can have a performance impact. We recommend using metadata formatting if your grid contains rows with different format types, and fewer, columns due to the performance impact.