Want this question answered?
is a combination of formatting options that is named and saved
Style
A style or a format template.
A style in Excel is a combination of formatting options that is named and saved as part of your current spreadsheet file. The new style can then quickly be applied to data and cells in the spreadsheet.
Banded Rows
Banded Rows
Clear formatting
clear formatting
clear formatting
clear formatting
Any conflicting formatting will be replaced by the style that is being applied. Whatever formatting that may have already been applied to the cell that is different to the style will be set to be the same as the style.
Select that portion then click another formatting style in Home tab Style section.