How can I make my spreadsheet look like in the picture below? Starting row 5, I want to color the entire row based on the status in Column L.

enter image description here

  • Any answers on this please?
    – user54830
    Dec 11, 2013 at 21:49
  • 1
    Take a look at webapps.stackexchange.com/questions/16745/… The accepted answer there is probably exactly what you need. Or at least a good starting point. (Since I can't comment or mark the question as duplicate because of my reputation, I had to write a new answer.)
    – Georg
    Dec 12, 2013 at 16:17
  • It worked with few changes on the codes. Thanks guys! You guys are awesome.
    – user54830
    Dec 12, 2013 at 23:58


Browse other questions tagged or ask your own question.