Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare data
I have a range of manually entered data (ie A2:c6). I want to compare the data in the a2:c6 range to data that was manually entered into (ie d2:f6). I want the spreadsheet to let me know in some manner if the data is the same or is not the same in these ranges. If it could tell me what cells dont match that would be good also. -- dr chuck |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare data
Tim,
I copied your code but had to delete "else" for it to work. All cells in A2:C6 are bring coloured irrespective of data mismatch. Is this what is intended or only the mismatched cell(s) is(are) to be coloured. -- Robert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare data
Personally I'd do it with conditional formatting to highlight the differences between the 2 sets of data. Go in to cell D2, then choose Conditional Formatting from the Format Menu bar Under Condition 1 choose "Formula is" and then type =IF(A2<D2,TRUE,FALSE) in to the box on the right. Click Format and choose how you want to highlight the differences (eg in red text). Then click Add This will compare cell D2 to cell A2 and if they are different then D2 will show in a different format And if you Format Copy that cell to your other ranges it'll do the rest. Hope that makes sense? Lee -- roundabout ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message2425323.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare data
Thanks Lee, I prefer VBA for my application.
-- Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data | Excel Discussion (Misc queries) | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
Need help using VBA to compare data in Excel columns, then manipulating data | Excel Programming | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
compare data from one column with another and compare result to yet another | Excel Programming |