Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to develop a spreadsheet to track implementation of patches/service packs on different machines. I have 2 columns (A & B) representing different machines. Each column contains a KB or Q article number (ex: KB823803; Q147222). Each column is sorted. I need to be able to compare the entries on each row. If they are the same, indicate by either: 1. Change the backgroun color of the two cells to green if they are the same. 2. Add "same" in the C column, same row as the row being compared. 3. Any other simply and obvious indication that the 2 values being compared are the same. If they are different, basically do the same thing, just indicate they are different. Can anyone suggest how I can quickly accomplish this? I am somewhat familiar with VBscripting if that helps. TIA, Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare values of two columns | Excel Worksheet Functions | |||
Compare values in different columns | Excel Discussion (Misc queries) | |||
I want to compare the values in two columns | Excel Discussion (Misc queries) | |||
Compare values in columns | New Users to Excel | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |