Magic!

I didn't realise the 'formula is' referred to the condition - I thought it
referred to the nature of the cell contents.

You're all brilliant - thanks to all who dug me out of that one...

"Bob Phillips" wrote in message
...
Yes it will, just select all of your target cells (I have assumed A1 is
the
first selected), and then in CF change Condition1 to Formula Is, and add
the
formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"merlin" wrote in message
...
will that work in the conditional formatting statement? I think it has to
be
generic so I'm not sure how to reference the cell it applies to in that
context.


"Bob Phillips" wrote in message
...
How about using a formula of

=UPPER(LEFT(A1,1))="E"

etc

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"merlin" wrote in message
...
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.