Hi All,

Is this possible to compare two set rows and produce high the cells with colors.

Like Am having Excel with set of values:

A1 -A20 I have random Values.And B1- B20 I have random Values..The Macro should compare the B1 -B20 Cell values to A1-A20(Respective cells) and Make colors in the Brow if the B cell Values <> 5% of A cells value..


Any help greatly appreciated...

Thanks,
Lakshmanan