Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2012, 02:43 AM
userman userman is offline check if all the lines are the same Windows XP check if all the lines are the same Office 2003
Advanced Beginner
check if all the lines are the same
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default check if all the lines are the same

hello!



I want to select some cells and to click a button in order to check for and possibly highlight the differences of the text between all the rows of the text

how can I do this?

thanks!
Reply With Quote
  #2  
Old 06-25-2012, 06:17 AM
userman userman is offline check if all the lines are the same Windows XP check if all the lines are the same Office 2003
Advanced Beginner
check if all the lines are the same
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default

anyone??????
Reply With Quote
  #3  
Old 06-25-2012, 07:49 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline check if all the lines are the same Windows 7 32bit check if all the lines are the same Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Can you give a couple of specific examples and also help us understand why you want to do this in Excel?
Reply With Quote
  #4  
Old 06-27-2012, 08:45 AM
userman userman is offline check if all the lines are the same Windows XP check if all the lines are the same Office 2003
Advanced Beginner
check if all the lines are the same
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default

here is an example

I want to check this, in order to locate errors fast, especially when the xls is generated by OCR process

I want to do this in Excel because I work mainly with that format, but any other fast way would be ok
Attached Files
File Type: xls Book1.xls (13.5 KB, 14 views)
Reply With Quote
  #5  
Old 06-27-2012, 03:49 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline check if all the lines are the same Windows 7 32bit check if all the lines are the same Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Your attachment just contains some lists; it doesn't show how you want them compared and how you want them highlighted.
Do you want them all compared to the first line, or to each line above, or.... ?
Reply With Quote
  #6  
Old 06-30-2012, 03:38 AM
userman userman is offline check if all the lines are the same Windows XP check if all the lines are the same Office 2003
Advanced Beginner
check if all the lines are the same
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default

each cell should be compared to the others, and be colored uniquely, so the result should be this:
Attached Files
File Type: xls Book1.xls (14.0 KB, 13 views)
Reply With Quote
  #7  
Old 07-04-2012, 01:27 PM
userman userman is offline check if all the lines are the same Windows XP check if all the lines are the same Office 2003
Advanced Beginner
check if all the lines are the same
 
Join Date: Sep 2010
Posts: 52
userman is on a distinguished road
Default

or maybe select some cells and compare them each other and highlight the different ones

any hint?
Reply With Quote
  #8  
Old 07-05-2012, 03:21 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline check if all the lines are the same Windows 7 32bit check if all the lines are the same Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Sorry for the slow reply - I've been really busy.

The degree of difficulty depends on whether you can assume that the cells with each piece of text are clumped together in groups. If they are, and if you are willing to compromise on the colours, then you could differentiate between them using conditional formatting to put borders on the cells.

If you want to go the VBA route then you'll need to loop through the cells in each column, identify each distinct value and associate a colour with that value which would be used to fill the cell's interior.

Have a go and post back if you're having problems with whichever approach you go for.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Link word check box to access check box Mrkieth Word 4 01-30-2012 06:43 AM
check if all the lines are the same Getting blank lines instead of supressed lines. Welshie82 Mail Merge 2 11-14-2011 01:41 AM
check if all the lines are the same This should be easy - check box RIKIL Mail Merge 10 07-19-2011 08:03 PM
check if all the lines are the same Check Boxes jellyrolls Office 4 07-15-2011 08:07 PM
Need Help with Using a Check Box Nick9589 Excel 1 05-01-2010 09:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft