Excel 2010: Highlight Cells in Column with Exact Condition...

**kmarks247** · 01-17-2013, 01:57 PM

Hi all.

I have a spreadsheet with a column that contains different ID's mixed in with other general text. The one constant is that all the ID's start with either a capital "E" or capital "P". Is there a way to return a true/false or even just "highlight" cells that meet that criteria? Example of what is in a cell below. Thanks in advance!

Example 1: E9BB15248000 // Speck 20
Example 2: Exclude one EI316V1J548 // Stack Pricing

In some cases the ID is at the beggining, sometimes in the middle of the cell text and others at the end which is why I'm hoping to find a way to mark out those that simply contain a capital E or P. Thanks again!

**ChemistB** · 01-17-2013, 03:11 PM

Finding the Capital E is easy. =ISNUMBER(FIND("E",A1)) returns True or False
However, let's say the your second example was
Exclude one RI316V1J548 // Stack Pricing
You'd still get "True" Because of the E in Exclude. :-/