Compare 2 cells from 2 sheets

[madeline32]

Can someone help me with this one, I will like a macro to compare row one to row one on sheet 2 column A. If the number is the same then it will compare from the same row column K from sheet 1 and column m from sheet2. If it is less then copy to sheet4 and highlight in red, if more than highlight in blue and if equal green. I will really appreciate it.

 

[madeline32]

Can someone help me with this one, I will like a macro to compare row one to row one on sheet 2 column A. If the number is the same then it will compare from the same row column K from sheet 1 and column m from sheet2. If it is less then copy to sheet4 and highlight in red, if more than highlight in blue and if equal green. I will really appreciate it.

Anyone?

 

[Dryver14]

Your description is not very clear,

for instance the last part if it less copy to sheet 4 and red if more, blue if same green, do theses figures move to sheet 4 before changing colour?

 

[Dryver14]

In the first line you say compare row 1 to sheet2 A1,

what do you mean by row 1? the whole row? We love to help, but can not if we do not understand the question.

 

[madeline32]

[QUser14;3433380]In the first line you say compare row 1 to sheet2 A1,

what do you mean by row 1? the whole row? We love to help, but can not if we do not understand the question.[/QUOTE]

Ok sorry about that, learning two new languages Macro and English.

Let see if I can explain a little better.

I will like to compare from Sheet1 (A1) to (A1) from sheet2
If they are the same then compare G1 from sheet1 to C1 in sheet2, if in that comparison G1 >C1 copy to sheet3 and color row in sheet3 to blue, if G1<C1 copy to sheet3 and color row in sheet3 to Blue an if G1=C1 copy to sheet3 and color row to green. I if A1 from sheet1 not the same with A1 from sheet2 do thesame with row to B2 etc..

 

[madeline32]

Ok sorry about that, learning two new languages Macro and English.

Let see if I can explain a little better.

I will like to compare from Sheet1 (A1) to (A1) from sheet2
If they are the same then compare G1 from sheet1 to C1 in sheet2, if in that comparison G1 >C1 copy to sheet3 and color row in sheet3 to blue,

 

[madeline32]

if G1 is less than C1 copy to sheet3 and color row in sheet3 to Blue an if G1=C1 copy to sheet3 and color row to green. I if A1 from sheet1 not the same with A1 from sheet2 do thesame with row to B2 etc..