| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check and Highlight!
I have two columns A & B. I need to first check if the Value in Column
B exists in Column A if yes then Highlight the Value in Column A. So... Name1 Name2 Dude Harry Joe Sally Bob Joe Result: the cell with Joe in Name1(ColumnA) should be Highlighted. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check and Highlight!
You can use conditional formating, with a formula like this:
=(MATCH(A2,$B$2:$B$4,0)0) It will be true if the value on cell A2 is present in the list in B2:B4. This can be applied to cell A2 and then copy format to the other cells. " wrote: I have two columns A & B. I need to first check if the Value in Column B exists in Column A if yes then Highlight the Value in Column A. So... Name1 Name2 Dude Harry Joe Sally Bob Joe Result: the cell with Joe in Name1(ColumnA) should be Highlighted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check matching strings in 3 columns | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| check boxes that highlight row | Excel Discussion (Misc queries) | |||
| How to check for duplicates in a list of names and dates | Excel Discussion (Misc queries) | |||
| How do I check formatting in an if-then statement | Excel Worksheet Functions | |||
Linear Mode
