yogi_Conditionally Format Rows In Which Column A Houses 'closed'

Google Spreadsheet   Post  #2028

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Marc Simmons126 :

https://productforums.google.com/forum/#!topic/docs/2HjB3a4jeFQ;context-place=mydiscussions

Conditional formatting of row (not column)

 

I have a google sheets spreadsheet that includes a column where the the cell's optional content is "open" or "closed".  I would like to make the row have a fill color of grey automatically when the value in this cell is "closed". Is there any way to do this?  Thanks for any help

------------------------------------------------------------------------------------------------------------