Vba code for comparing same month numbers of 2 consecutive years in separate columns and coloring the latest month cell with var over 15%

[ankitgoyal1520]

Suppose
Col 1... col 2.. col 12..col 13..Col 14.. Col..25 Col..26
Jan20..Feb20..dec20..jan21..feb21.. Jan22..Feb..22

The vba code will compare value of jan20 with jan21 and color the cell in jan 21, if variance is greater than 15% and go on comparing jan 21 to Jan22 and color jan 22 column cells

 

[6StringJazzer]

From this brief description I would say that it would be easier to use conditional formatting instead of VBA for this. But there is not quite enough information to do either. You describe a variance, but you don't show it in your data layout, or how it is determined. Consider using XL2BB to post your layout, or at least copy the cells and paste as a table.