2.1.251 Part 1 Section 17.7.6.6, tblStylePr (Style Conditional Table Formatting Properties)

a.    The standard specifies the precedence order in which conditional formatting should be applied.

When specified, Office applies conditional formats in the following order (therefore subsequent formats override properties on previous formats):

  • Odd row banding, even row banding

  • Odd column banding, even column banding

  • First column, last column

  • First row, last row

    • Top left, top right, bottom left, bottom right

    Refer to ST_TblStyleOverrideType, §17.18.89(a) for information about the conditional formatting values Microsoft Office recognizes.

Show: