Excel Conditional Formatting

Feb 23, 2018
Reaction score
I have a row of cells that contain numbers. A2 to A10

In the row below I have the conditional formatiing corresponding to the cells above. B2 to B10

I only want to format for the number 41.

B2 CF is =search("41", A2) formatted to fill the cell in blue

But other numbers conataining 4 and 1 (412 or -4143) are also formatting blue!!

How do I make it so it only formats for 41

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question