In the Conditional Formatting options, set Apply to to Values and totals.
Apply to
Values and totals