First let me apologize if this has been answered before... I have searched this site & all across the web, and no formula found works for me... I hope someone here can help.
I have two spreadsheets (in 2 workbooks). One SS is a listing of Store Samples, the other is a Price List of products.
The Store Samples SS has a column named 'ItemNo' (Col E), the entries are short, 5 chars long.
The Pricing List SS has a column named 'Item #' (Col E), the entries are longer, 11 chars long. (NOTE: this is updated monthly with a whole new spreadsheet - so I'm hoping for an easy CF formula to paste as needed.)
The Item #'s in Pricing List contain the same ItemNo from StoreSamples, (just with additional letters/numbers in front & back of orig ItemNo, added by the distributors).
On the pricing spreadsheet, I would like the cells in the Item number column to be highlighted if the cell contains text (regardless of case) that is found in the ItemNo column of the Store Samples SS.
I hope this makes sense to all of you brilliant minds out there... cause this lady is ready to rip her hair out... I know this can be done... but HOW???!!!???
I have two spreadsheets (in 2 workbooks). One SS is a listing of Store Samples, the other is a Price List of products.
The Store Samples SS has a column named 'ItemNo' (Col E), the entries are short, 5 chars long.
The Pricing List SS has a column named 'Item #' (Col E), the entries are longer, 11 chars long. (NOTE: this is updated monthly with a whole new spreadsheet - so I'm hoping for an easy CF formula to paste as needed.)
The Item #'s in Pricing List contain the same ItemNo from StoreSamples, (just with additional letters/numbers in front & back of orig ItemNo, added by the distributors).
On the pricing spreadsheet, I would like the cells in the Item number column to be highlighted if the cell contains text (regardless of case) that is found in the ItemNo column of the Store Samples SS.
I hope this makes sense to all of you brilliant minds out there... cause this lady is ready to rip her hair out... I know this can be done... but HOW???!!!???
