How do I write a macro that looks at column D and highlights the entire row based on that value? The macro needs to look at the values of a certain cell and based on that value change the entire row to one color or another.
For example, I work on a list of quote requests. The list contains requests from four different vendors. Because the data on each row of the list is so similar, I would like to color code the row based on the vendor's name so that the line can be easily identified.
Specifically, Row D contains the vendors name. - The data on that row, extends from column A through BA. A sample spreadsheet is attached.