Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 line in a different way automatically?

share|improve this question

migrated from superuser.com Nov 4 '10 at 10:12

This question came from our site for computer enthusiasts and power users.

By "whole line" do you mean entire row? – Tyler Nov 4 '10 at 4:03
@Tyler: Yes, I meant row. Sorry. – BrunoLM Nov 4 '10 at 8:58
Read with answer on Stack Overflow: stackoverflow.com/a/3860310/1536038 – Jacob Jan Tuinstra Feb 15 '13 at 22:32

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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