Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare column color row
Hi guys,
Hope i can get some input on this. the scenarios is this: sheet 1 column b sheet 2 column a for each row in sheet 2 col B compare with each row sheet1 col A. IF row equal, then change color for the equal row in sheet 2 col A. Thnx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare column color row
On Jul 23, 9:30*am, SangelNet wrote:
Hi guys, Hope i can get some input on this. the scenarios is this: sheet 1 *column b sheet 2 column a for each row in sheet 2 col B compare with each row sheet1 col A. IF row equal, then change color for the equal row in sheet 2 col A. Thnx "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare column color row
On 23/07/2010 15:30, SangelNet wrote:
Hi guys, Hope i can get some input on this. the scenarios is this: sheet 1 column b sheet 2 column a for each row in sheet 2 col B compare with each row sheet1 col A. IF row equal, then change color for the equal row in sheet 2 col A. Thnx Hi SangelNet, Sub CmPare() Dim i As Long Dim lastRow As Long lastRow = Sheets("Sheet1").Cells(Rows.Count, "B").End(xlUp).Row For i = 1 To lastRow If Sheets("Sheet1").Range("B" & i) = Sheets("Sheet2").Range("A" & i) Then Sheets("Sheet2").Range("A" & i).Interior.ColorIndex = 3 End If Next i End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
compare data from one column with another and compare result to yet another | Excel Programming |