I have a sheet that I'd like items to automatically apply strikethrough when I input "DONE" in the status column.
So far I've got the cell that actually says "DONE" to strikethrough, that is easy.
My problem is how to strikethrough the rest of the columns in that row when that cell says done.
I've had various success in the past but it seemed to take a new rule for each row (check cell to your right, is it "X", if so; format).
Is there a way to have a relative reference in the conditional formatting?
Essentially it would be something like this, but without having to make a new rule for every line:
Image for more context:
Capture.PNG
Thanks!
Bookmarks