excel - Copying Conditionally formatted Cell colors from one sheet to another - Stack Overflow

I have two excel sheets

Sheet 1: has columns C6:M78 and is filled with the priority value The priority ranges from 0-4 and I used conditional formatting to break this up into green, yellow, and red.

Sheet 2: Is laid out exactly the same as sheet 1 (C6:M78) HOWEVER with price I am trying to overlay the colors from sheet 1 to sheet 2 so the priority color (red, yellow, or green) shades in the price

I tried running a macro with .interior.color however this does not work on conditional formatting. I verified this by coloring one of the cells with fill and the macro worked.

How can I do this?

I have two excel sheets

Sheet 1: has columns C6:M78 and is filled with the priority value The priority ranges from 0-4 and I used conditional formatting to break this up into green, yellow, and red.

Sheet 2: Is laid out exactly the same as sheet 1 (C6:M78) HOWEVER with price I am trying to overlay the colors from sheet 1 to sheet 2 so the priority color (red, yellow, or green) shades in the price

I tried running a macro with .interior.color however this does not work on conditional formatting. I verified this by coloring one of the cells with fill and the macro worked.

How can I do this?

• excel
• conditional-formatting

Share Improve this question Follow asked Jan 6 at 21:54 excelhelppls excelhelppls 1 2

• 1 Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented Jan 6 at 22:33
• can u try this : copy (sheet1) >paste (sheet2) > (in paste special option) select formatting only – p._phidot_ Commented Jan 7 at 8:34

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

You would highlight the range on sheet1 C6:M78 and hit CTRL + C. Then, highlight the range you want to reformat and hit Right-Click + R and it will copy the same formatting rules to color them based on their values.

Also when you right click the cells you'll see the "Paste Options" and can select "Formatting" which has a paintbrush and % as its logo.