Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |