I have a cell that can be OK, ERROR or WARNING. When it is changed to OK I want to modify the whole row in some way. I was thinking about to dash all cells.

Is it possible? Or is there something I can do to see the whole row in a different way automatically?


1 Answer 1


New Google Sheets allows the use of a custom formula for conditional formatting, so for example:

WA8916 example

This is using highlighting for the modification as I am not sure what you mean by dash all cells.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.