Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
    
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
add comment

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

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

1 Answer

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
add comment

Your Answer

 
discard

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.