| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Ken wrote
Excel 2000 ... Col B contains 1000 alpha-numerics (many repeat) Col D contains 50 alpha-numerics (none repeat) I would like "Conditional Formatting" Formula in Col B to high-lite all alpha-numerics not found in Col D. Thanks ... Kha If I understand what you mean by alph-numerics, how about: Select Col B Format|Conditional Formatting|Formula Is =(COUNTIF(D:D,B1)=0)*ISTEXT(B1) Choose color from Patterns -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format Titles | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| make a conditional format the default | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
