ankitgoyal1520
New Member
- Joined
- Mar 14, 2024
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
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
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