Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to highlight what's different between two columns
Hello,
I have two columns with alphanumeric data ("a" & "b"). The data in the cells is not necessarily in the same row all the time (may or may not be aligned). Sometimes one column is longer than the other. Here's an example: Column A Column B 10100A 10100A 10200A 10200A 10300A 10300A 10400A 10400A 10500A 10600A 10600A 10700A 10700A 10800A 10800A 10900B 10900A Is there a way to highlight the cells that are different in the two columns??? Either by using a formula in column "c", or by using conditional formatting by selecting the whole column from the top ("a" & "b")??? In this example these are the cells that need to be highlighted: "10500A" (Because it is in "a", but not in "b"). "10900A" (Because it is in "a", but not in "b"). "10900B" (Because it is in "b", but not in "a"). Help please!!! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to highlight what's different between two columns | Excel Discussion (Misc queries) | |||
Highlight rows based on '1' or blank in all columns on a row | Excel Worksheet Functions | |||
Find and Highlight duplicates in 5 non-adjacent columns | New Users to Excel | |||
Highlighting rows/columns is there a way to darken the highlight? | Excel Discussion (Misc queries) | |||
highlight dups in one of two columns | Excel Worksheet Functions |