Find and Format cells with specific text

Hi,

I need help to create a code that finds all cells within the sheet containing "NR/" and apply color to them. Attached is a sample book having several occurrences of it, where only part of the cell content meets that criteria (NR/). Regardless of the rest of the content within the cell, I need those cells to be applied a color (any color will do).

Any help will be appreciated.

Thanks!

You can apply Conditional Formatting...

VBA

Please Login or Register  to view this content.

Hi Jindon,

Thank you for your help! The code works, but it's until now that I see it applied, I'm coming to realize my approach was probably not the best to fit my need. What I'd rather have, is any cell in column B (SKU), highlighted in color, if and only if, the adjacent cells in the same row, have content starting with NR/ only, vs having content that starts with any other letters (BS, AG, AL, etc). The last 2 items within the spreadsheet (29 & 30) are the only cases within the sheet meeting that criteria, and those are the ones I actually need to target.

I hope you can help me with this!

Thanks!

Hi Marvin!,

Yes, I have followed the steps you listed. My need to have code to do it for me, is that having to do it on several sheets becomes time consuming and not exactly efficient. But thanks for taking the time to respond to my post.

Hi Jindon,

Yes, that's exactly what I needed. Again, thank you SO much for your help! I'll wait to see if you can answer Marvin's question, and then I'll mark this post as solved.

Thanks!