Using Excel Conditional formatting on a range, "applies to" a variable number of rows

Viewed 39

I want to have the value (X) in a cell $A:$A conditionally format cells on (X) number of rows down.

E.g. "Applies to" $B1:$B( ROW() + (X) )

This is what I'm hoping to get;

0 Answers
Related