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
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