conditional formatting
I had been formatting a cell colour to pink green or blue depending on if it
contained E, M or L.
I've now had to change my cell contents to E1, E2, E3, E4 etc instead of
just 'E' so I've gone over my limit of 3 conditional formats.
Is there a way I can conditionally format based just on the letter E M or L
and not the number with it?
Or can you think of another way to achieve the same thing?
Much obliged for any help suggested.
|