Macro to Fill Specific Rows and Columns with Color Based on Cell Value

Hello all,

Just need a little help writing a macro that will fill certain cells with a color across several columns based on a cell value in one column.

If a cell within the column marked “SODS” (identified by the row 1 header), contains the word “OPEN”, then the row that contains the “OPEN” will be filled with a grey color (color index 15) in the following columns: “Excl”, “Notes”, and “Site” (all noted in row 1 header).

Help is most appreciated – thank you!


Questions also posed at Mr. Excel http://www.mrexcel.com/forum/showthread.php?t=533434