Auto fill cells based on their color

[luke360]

Hoping someone can shed some light on this, I am looking for a macro that would fill all the red cells with the text at the top of their respected column i.e AWV, CPE, CCM etc. I have not yet found anything that can recognize each individual column, always fills red cells with the same text.
Thank you.

 

[Computerman]

I can think of two ways to do this. first use Conditional Formatting. The second is to fill in all the cells under each column with the text you want, but change the font color to white. White text on a white background won't show, but change the cell fill color to Red and that white text will be visible

hope that helps
Computerman

 

[Fluff]

Hi & welcome to MrExcel.
How are the cells being filled?

 

[luke360]

Hi & welcome to MrExcel.
How are the cells being filled?

Conditional formatting

 

[Fluff]

In that case why not just put a formula in the cells, using the CF criteria? Something along the lines of
=IF(your CF formula=TRUE,H$1,"")