Home » Forums » Open Source Learning Center » Question and Answer

conditional format help

Submitted by craiganderson1975 on 13 December, 2012 - 22:16

Hi

I have 2 cells A1 & B1 .both contain text

I want it to apply the rule if the exact text of B1 is contained somewhere within the text of A1

eg A1: "forum.abcnanmeter" B1: "nanmeter"

it would apply rule as the exact text of B1 is contained within A1

Thanks in adavnce

‹ equation with 2 unknown values Forgot personal.xls password ›
»

http://www.excelexperts.com/E

Submitted by AndyLitch on 14 December, 2012 - 05:12.

http://www.excelexperts.com/Excel-Tips-Does-a-cell-contain-a-string

Tip#58

»