How to color a cell, by the color next to it.

[TheMacroMan]

I have a long 1000+ row of data that I am checking. My program colors incorrect cells red and blank cells orange. I need to be able to set the colors back to the original values. Is there a way that I could take the color one column (to the left of right) and use it to color the correct cells? If it changed anything (don't think it does) this is in excel 2010

 

[Redwolfx]

Highlight the column that has the correct colors. From the Home Tab click on the paint brush (Format Painter) in the clipboard section, then highlight the column you want to have the corrected colors.

So if it were B and C

Click on the B to highlight the column, Click on the paint brush, click on C to highlight that column. Done

 

[Gavin T]

In VBA you would paste as formats.

Columns("B").Copy
Columns("C").PasteSpecial xlPasteFormats
Application.CutCopyMode = False

 

[TheMacroMan]

Highlight the column that has the correct colors. From the Home Tab click on the paint brush (Format Painter) in the clipboard section, then highlight the column you want to have the corrected colors.

So if it were B and C

Click on the B to highlight the column, Click on the paint brush, click on C to highlight that column. Done

Thanks, but this is for some people who have not used excel before. I would like something that I can set up as a button.

 

[Redwolfx]

Then Gavin's Code tied to a button is what you are looking for.