I would like a macro to automatically (when run) color rows in a range where it begins at $A$3 to $T (the last row will change regularly) based on a text value in column E. The two text values are "CP" and "LG" and I would like to give the "CP" row a color index of 35 and the "LG" rows a color index of 37. I would only like the row to be colored up to the last column in the range "T". Thanks in advance.