Conditional Format formula

lapta301

Well-known Member
Joined
Nov 12, 2004
Messages
964
I would appreciate any help with the following.
A1 contains the name of a city say Reading.
F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell.

So what I need is a CF formula that will check if the first 2 characters in A1 are anywhere in F1.

As ever any help is most appreciated.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,591
Office Version
365
Platform
Windows
How about
=ISNUMBER(SEARCH(LEFT(A1,2),F1))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,591
Office Version
365
Platform
Windows
Glad to help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,095,418
Messages
5,444,346
Members
405,278
Latest member
karen1

This Week's Hot Topics

Top