Re: excel macro for changing the row color

[ubns]

is it possible to write a macro or get the code to change the color of row depending on the cell value (in text, not numeric value).

To explain further - there are four options in the list box (or drop down). One option is - Started. When we select startred it should change the row color to yellow. when we select another option --- completed, then the row color should change to green.