Conditional Formatting formula applies to first cell but not the rest?
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
And A3 gets strikethrough, but nothing after that.
Here is the formula. How am I applying this range incorrectly?
Posted Feb 10, 2025, 4:45 PM UTC
16