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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This was just a personal choice as they all did the job.