Comparing Value

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

Hi,

Try this:

Please Login or Register  to view this content.

Hi djdjdj,

Thanks for the response.Here i have attached my original Requirement sheet.Here I tried with your code ..But am failing..Here I need to compare the X2 Values with X1,X3 Value with X2,X4 value with X3..like wise till end i need to compare..

When comparing X2 with X1 the macro should populate the color based on the below condition.

IF X2 = X1 (No need of color change)
IF X2 > 5% of X1 (Need to generate Red Color)
IF X2< 5% of X1 (Need to Generate Yellow color)


Like wise for Others till X7:

IF X3 = X2 (No need of color change)
IF X3 > 5% of X2 (Need to generate Red Color)
IF X3< 5% of X2 (Need to Generate Yellow color)


Thanks in advance,
Lakshmanan

Hi Sktneer,

Thats awesome..It is working fine.One more query.If i have more number of sheet which having what should i do?..I have tried and it is working for the current sheet.Pls find the attached sheet for you reference....

Hi Sktneer,

control+alt+F9 is not refreshing datas.But no pbm for me..Thanks for your help and you spent your valuable time for me..Im mark it as solved now..

Laxmanan