r/googlesheets•
gfhyde

Conditional Formatting formula applies to first cell but not the rest?

Unsolved

I've created a sheet of rankings for my baseball league and I'd like to strikethough the text in each of the rows if one of the players is picked. I thought I could accomplish this by either putting an x or a number in one of the cells, then creating a formula for the rest of the sheet or even just the row of numbers to strikethrough the text.

With everything I've tried, so far only the first cell in the selection gets the conditional formatting.

With the formula I'm using right now, I place an x in P3. I'd prefer to do it with "=P3>0" but that doesn't seem to make a difference anyway

https://preview.redd.it/5fxgb7lvbcie1.png?width=129&format=png&auto=webp&s=84ea38a9bba048d1913b0091bdff1006300759fa

And A3 gets strikethrough, but nothing after that.

https://preview.redd.it/827s6oexbcie1.png?width=821&format=png&auto=webp&s=bc4a15b2966be3567de5a3a649b656ecd3d34344

Here is the formula. How am I applying this range incorrectly?

https://preview.redd.it/jxpe09glbcie1.png?width=407&format=png&auto=webp&s=940e2e55272efc7801307dd04b3a0f9c495def09

Posted Feb 10, 2025, 4:45 PM UTC

16
Loading comments…