Skip to content

removecxf

Remove all conditional formatting from a range.

removecxf(crDst)

Removes any conditional-formatting rules attached to the cells in crDst. The cells’ values and base styles are unchanged; only the conditional rules are dropped.

removecxf(A1:A100)
  • applycxf — Apply conditional formatting to a range.
  • applyxf — Apply a cell style (named or property-pair) to a range.