Conditional formatting or VBA CODES or formulas

Dear Experts,

Could you please help me ?

There are 2 columns in my excel sheet one is of item codes & other is of description.
I need to highlight specific item codes within a range. range which consist of 1st 3 letters of the item code.
If 1st 3 letters from my range matches with the beginning of item codes the item codes cell should be highlighted.

And in description column there are many words which form a sentence. i have a specific range of words which should match with the description column & description cell should be highlighted.

Please note item codes & description always changes

Can somebody please help me urgently ??

i have attached file for reference.

Thanks

Swapnil Khade

Highlight the range in column A

• Click Conditional Format
• Highlight Cell Rules
• Text That Contains
• Add the letters and choose the color

Hii rob.callaghan..

Thank you for your quick response.

I have tried that but it is only for single search text i need to search multiple text & highlight multiple text.

Can you help?

try this file

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Dear Sir,

Thanks for your quick reply.

I am very grateful to you as you are trying to help.

Shall i check & get back to you since i need to check each & every case?

Thank you

Dear Sir,

There is no relation in in between item code column & description column.

i need to highlight column a separately irrespective of column b

Could you please share with me considering above?

all B will be highlighted in this case.

yes.

cells in column b should be highlighted with reference to column f
similarly cells in column a should be highlighted with reference to column e

Can we get an idea the cells which are highlighted in column a or b are from which cells of column (attached example)

Also please confirm whether we are using conditional formatting only or any other formulas ?

Use CF for B

Please Login or Register  to view this content.

Look at #4. it s the same without part 2

Please Login or Register  to view this content.

Sir,

While pasting below formula there is an error

=SUM(--ISNUMBER(SEARCH($F$3:$F$364;B2)))

Separator ; must be replaced to ,. Look at the attachment in my post.

Dear Sir,

Yes. Thank you i replaced to , & the formula which you have suggested is helping to highlight the cells but some random cells are getting selected.

Unfortunately i am not not getting the results . i dont know why.

May be i am exhausted.

i will again try tomorrow if it helps.

You were great to help me.

Thanks a lot for understanding truly.

Thank you friend.