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.
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
I tried using the Search formula in conditional formatting and it didn't work.
Your help would be greatly appreciated.