Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Formula
I need a way to find cells that contain information that is included in
another cell. Example: A B 1 John Smith Smith, John 2 Jane Doe ABC Company 3 Billy Jones Jones, Billy I'd like to use conditional formatting to highlight cells B1 and B3 because it contains a word that is also in cells A1 and A3 respectively. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set a formula, that add next cell reference in a Formula | Excel Worksheet Functions | |||
Formula to reference every second row | Excel Discussion (Misc queries) | |||
Reference formula | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions |