| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting chances in shared worksheets
Two Excel Worksheets - need to idenify non matching records ( in changing
rows /columns) ? How |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highlighting chances in shared worksheets
Hope this works for you:
Sub Compare2Shts() For Each Cell In Worksheets("CompareSheet#1").UsedRange If Cell.Value < Worksheets("CompareSheet#2").Range(Cell.Address) Then Cell.Interior.ColorIndex = 3 End If Next For Each Cell In Worksheets("CompareSheet#2").UsedRange If Cell.Value < Worksheets("CompareSheet#1").Range(Cell.Address) Then Cell.Interior.ColorIndex = 3 End If Next End Sub Regards, Ryan--- -- RyGuy "Dream" wrote: Two Excel Worksheets - need to idenify non matching records ( in changing rows /columns) ? How |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
| Need help! Chances are it's a simple formula I'm overlooking | Excel Discussion (Misc queries) | |||
| Terrible Excel Ruined My Chances of Graduation | Excel Discussion (Misc queries) | |||
| Comparing worksheets in Excel and highlighting changes | Excel Worksheet Functions | |||
| Worksheets Vanishing in Shared Workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
