# Compare 2 cells from 2 sheets

##### New Member
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.

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

##### New Member
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

##### Well-known Member
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

##### Well-known Member
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.

##### New Member

[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..

##### New Member
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,

##### New Member
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..

Replies
1
Views
15
Replies
22
Views
347
Replies
13
Views
390
Replies
2
Views
88
Replies
1
Views
177

1,129,589
Messages
5,637,278
Members
416,963
Latest member
samfuge

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back