| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two worksheets and highlight the one sheet’s difference from the other one
Does anyone know how to do this? Thank you for your great help -- minrufen ----------------------------------------------------------------------- minrufeng's Profile: http://www.excelforum.com/member.php...fo&userid=2620 View this thread: http://www.excelforum.com/showthread.php?threadid=51636 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compare two worksheets and highlight the one sheet's difference from the other one
for each cell in Activesheet.usedRange
if cell.Value < Worksheets("Sheet2").Range(cell.Address) then cell.Interior.ColorIndex = 3 end if Next -- Regards, Tom Ogilvy "minrufeng" wrote in message ... Does anyone know how to do this? Thank you for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=516364 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare difference between 2 worksheets 2003 | Excel Discussion (Misc queries) | |||
| Compare & highlight changes between two worksheets? | Excel Worksheet Functions | |||
| Compare data from two worksheets and display difference into 3rd s | Excel Worksheet Functions | |||
| compare info in 4 worksheets and highlight fields that are the sam | Excel Worksheet Functions | |||
| How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) | |||
![minrufeng[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
