Highlighting Rows with CF based on cell with sequencial values
<p>I can't seem to nail this down. Using Excel 2010 I've got a column (B) with various 'signals' that each have a sequential number. i.e. 'IP1', IP2', IP3', 'FLOW1', 'FLOW2', 'GV1', 'GV2", and so on... I'm trying to highlight the entire row based on the type of signal (IP, FLOW, GV, etc.) ignoring the sequential value. </p>

<p>Using the CF highlight rule for "text that Contains" only highlights the individual cell. Using this formula to highlight the entire row: =$B2="IP" does not give desired results because all my values have a number as well. I've also tried wildcards: =$B2="IP?" and =$B2="IP*" with no luck. </p>

<p>Is there a way to do this without creating one rule for each sequential signal? I'd even settle for something like this: =$B2="IP1","IP2","IP3" but that doesn't seem to work either. I'm a newby at Excel and know I'm dancing all around the answer here. I don't see this particular problem in other posts... </p>