NooneBug
NooneBug

Reputation: 53

Conditional Formatting w.r.t. a non-contiguous range

How can I make conditional formatting (in google sheets) based on non-contiguous cells in the same columns?

Example:

I want to highlight (with Bold) the maximum between [H4, H14, H24, H34 etc..] (i.e., all cells in H starting from H4, moving ten in ten).

How can I make this kind of conditional formatting?

Upvotes: 1

Views: 153

Answers (1)

player0
player0

Reputation: 1

try:

=H4=MAX(FILTER(H$4:H, MOD(ROW(H$4:H)-4, 10)=0))

0

Upvotes: 1

Related Questions