Conditional formatting copy and paste

[Vishaal]

Hi all,

Thanks in advance,

I have the following post and its solution

if with some condition

Hi all, we have the following sheet, and want to change the color if the condition meet according to E MAX LEVELQuantityExtra15001600Normal50035060 - 40% balance20071BELOW 30%10025 help pls

www.mrexcel.com

Now i want to use this in next column, i have data in next 25 column and want to copy paste but when we do that its not change custom formula, as we do copy paste formula

How can we do that, help pls

 

[hartsie]

To copy and paste conditional formatting, you can just copy, Control + C, and paste special, Control + Alt + V>T>Enter.

 

[Vishaal]

Thanks but it will not change C and B, its using in all column C and B formula, in next column not changed to D and C

 

[Toadstool]

Vishaal,

In your original example the conditional format target was two merged cells so if you copy and paste the conditional formatting (which used relative addressing) then it will change the formula by two columns, so D and E instead of B and C.

It may be easiest if you specify exactly which columns should have the format and exactly which columns are the source of that calculation.

Vishaal.xlsx
	B	C	D	E	F	G	H	I
1	MAX LEVEL	Qty	Max 2	Qty2	V1		V2
2	1500	1600	444	555
3	500	350	333	1
4	200	71	222	88
5	100	25	111	110
6	55	25	44	22
V2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H2:H6	Expression	=E2/D2<=0.3	text	NO
H2:H6	Expression	=AND(E2/D2<=0.6,E2/D2>=0.4)	text	NO
H2:H6	Expression	=AND(E2<=D2,E2/D2>0.6)	text	NO
H2:H6	Expression	=E2>D2	text	NO
F2:F6	Expression	=C2/B2<=0.3	text	NO
F2:F6	Expression	=AND(C2/B2<=0.6,C2/B2>=0.4)	text	NO
F2:F6	Expression	=AND(C2<=B2,C2/B2>0.6)	text	NO
F2:F6	Expression	=C2>B2	text	NO

 

[Vishaal]

Thanks Toadstool,

I will check and update

 

[hartsie]

Thanks but it will not change C and B, its using in all column C and B formula, in next column not changed to D and C

Thanks for the feedback.