Hi,

I have an excel sheet in which I've used Conditional formatting (Highlight Cells Rules) to highlight cells that met a certain criterion. I want the macro to Fill Color (yellow) the the whole column in which any cell has been highlighted.

Thanks so much.