Compare - Formats
The following cell formats can be compared:
It is compared whether the number format of the cells is different.
Compares the alignment of the cells (left, center, etc.)
All the font formattings are compared (font name, size, color, underline, etc.)
The cell borders are compared.
The background color of the cells is compared.
The cell protection and visibility of the cell to be compared.
Proceed as follows to compare the cell formats:
1. Click on formats.
2. Select "Enable formats". (The format icon changes from gray to black).
3. Select all of the formats that you want to compare.
In this example, the number formats and font sizes are compared.