Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

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

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.
0
Worldsplayground
Asked:
Worldsplayground
3 Solutions
 
redmondbCommented:
Hi, Worldsplayground.

Please see attached.

Edit: The Conditional Formatting formula is...
=IF(ISERROR(SEARCH("e",B1,1)),FALSE,TRUE)

Regards,
Brian.Beige..ish.xls
0
 
krishnakrkcCommented:
Hi


if you are looking for the first letter, try

=left(b1)="e"

Kris
0
 
barry houdiniCommented:
For anywhere in the cell it would be sufficient to use

=SEARCH("e",B1)

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

regards, barry
0
 
WorldsplaygroundAuthor Commented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now