dolphintabby
Member
I have a large table of data and I want conditional formatting to highlight an item if it contains a specific part of a text. For example part number is Z10105 but there are 1,000 of parts that begin with that series Z10105MJB, Z10105QZR,...etc, etc and I want a flag of highlighting it if it contains those 1st 6 characters. Please help. Thank you 