Share via

Conditional Format Spill Range

Anonymous
2022-12-21T14:47:57+00:00

I was wondering if it was possible to apply conditional formatting to a spill range, specifically, fill color to every other row? If not, does anyone know of a work around?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2022-12-21T15:29:01+00:00

Excel doesn't handle a spill range in the 'Applies to' box of a conditional formatting rule (yet - perhaps it will in the future).

You can create a rule of type 'Use a formula to determine which cells to format', with a formula such as

=AND($C2<>"",ISODD(ROW($C2)))

and apply it to the maximum possible range covered by the spill range. In this example, C2 is a cell in the top row of the spill range, in a column that is guaranteed to be filled by the formula.

Was this answer helpful?

3 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-21T15:35:07+00:00

    Yes, hopefully in the future. This will work for now. Thank-you.

    Was this answer helpful?

    0 comments