Hello,
i have two excel sheet with same value which i need to compare every day .with in same excel sheet i can compare easyly using conditional formating but in case of comparison between two excel sheet conditional formating is not working so i just want to know vba code which compare the value sheet 1 a1 and with sheet2 a1 and if it's doesn't match then the value which is in sheet 1 a1 should show in red color .
Configuration: Windows XP Internet Explorer 6.0
I have given a macro below
Sub test()
Dim r As Range, c As Range, j As Integer, k As Integer
With Worksheets("sheet1")
Set r = Range(.Range("A1"), .Range("A1").End(xlDown))
r.Cells.Interior.ColorIndex = xlNone
For Each c In r
j = c.Row
k = c.Column
If c = Worksheets("sheet2").Cells(j, k) Then
c.Interior.ColorIndex = 3
End If
Next c
End With
End Sub
Please rememner that only if A1 or any other cells in column A of sheet 1 is same as the entry in the same address in shseet2 that cell in sheet 1 will be red. suppose the same entry in any cell in sheet1 is found in some other address in sheet 2 the original cell in sheet 1 wil Not be red. |
Amd turion x2 rm-75(2.2ghz) compared to intel Descargar el serial del playstation 2 emulator 1.20.50 Electric sheep windows xp Excel 2007 compare two columns and remove duplicates from second Excel 2007 total from multi sheets Excel check if a value is in another sheet Excel highlight matching cells from 2 columns Excel sheets and web forms How do i do a search in excel How to compare two columns in excel How to compare two excel spreadsheets How to install sims 2 on mac Insert excel sheet in gmail email Modern warfare 2 error Modern warfare 2 hamachi Ntroduction of excel spreadsheet Stopping autofill in excel sheet Will 2 xbox live accounts be connected to same internet connection