View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merlin merlin is offline
external usenet poster
 
Posts: 27
Default 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.