Change color of cell if Cell B contains the letter E in it (Excel)

Posted on 2012-09-15
Last Modified: 2012-09-16
I am searching for a way using conditional formatting so that the following could work.
I would like cells in column L to fill in with a light beige color if the corresponding cell in column B contains the letter E in it.

For example:
If cell B13 has U569631, then cell L13 remains UNFILLED

If cell B14 has E001256, then cell L14 is filled in with Beige.

If cell B15 has C156200, the cell L15 remains UNFILLED

etc, etc.

I tried using the Search formula in conditional formatting and it didn't work.
Your help would be greatly appreciated.
Question by:Worldsplayground
    LVL 26

    Assisted Solution

    Hi, Worldsplayground.

    Please see attached.

    Edit: The Conditional Formatting formula is...

    LVL 18

    Accepted Solution


    if you are looking for the first letter, try


    LVL 50

    Assisted Solution

    by:barry houdini
    For anywhere in the cell it would be sufficient to use


    SEARCH isn't case-sensitive so that would highlight both "E" and "e". For a case-sensitive version replace SEARCH with FIND

    regards, barry

    Author Closing Comment

    Thank you guys.  I tested out each expert comment and they all work perfectly.  I did however find the =left(b1) easier to manimulate and change to suit my needs as it made more sense to me than the Search and NoError formula.
    This was just a personal choice as they all did the job.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now