| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlight dups in one of two columns
I have words in column A and B. I'd like to use conditional formating to
highlight just those words in A that also occur in B. The following is close, but I believe gives a mirror image of what I want. Appreciate any help. Thanks. 1. Select column B (click the letter B) 2. Choose Format Conditional formatting 3. In ""Condition 1"" choose ""Formula is""" 4. Enter this formula =(COUNTIF($A:$A,B1)=0)*(B1<"") 5. Click the ""Formats"" button and take your pick. OK.OK. -- Alan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
| Selecting different multiple columns | Excel Worksheet Functions | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
