Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight rows based on '1' or blank in all columns on a row | Excel Worksheet Functions | |||
Compare values in columns and highlight the smallest value | Excel Discussion (Misc queries) | |||
How to Highlight Two Rows With Two Columns of Duplicate Values | Excel Worksheet Functions | |||
highlight dups in one of two columns | Excel Worksheet Functions | |||
compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions |