How to change row color based on a single cell's value?

Posted by flyfisher on Super User See other posts from Super User or by flyfisher
Published on 2012-09-26T18:18:43Z Indexed on 2012/09/26 21:40 UTC
Read the original article Hit count: 164

I have a spreadsheet where I have cell within a row that will contain specific text via data validation. So for instance a cell could contain the text "Due in 7 Days", "Past Due", or "Closed".

I want the row color to change depending on the text that appears in the cell. So if the text "Past Due" appears in the cell I want that entire row to turn red, if "Due In 7 Days" appears the row should turn yellow, and if "Closed" the row would turn gray.

How can I do that?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about conditional-formatting