Might be simple... Cell Formating.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M.Siler - 14 Jun 2007 23:52 GMT

Is it possible to format a cell where numbers are one color and alpha is
another? I'm using Excel 2007?

At times it's hard to tell the difference between L's and Ones ( l1 )

Thanks,
Mark

Reply to this Message

Bernard Liengme - 15 Jun 2007 00:28 GMT

If you want digits and letters within one cell to have different colours I
cannot help other than to suggest you experiment with different fonts.

To make display text in one colour, use conditional formatting with formula
=ISTEXT(A1) and set the required colour. This will also display the selected
colour if you inadvertently press l (lower case L) when you want 1 (digit 1)

best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Is it possible to format a cell where numbers are one color and alpha is
> another? I'm using Excel 2007?
[quoted text clipped - 3 lines]
> Thanks,
> Mark

Reply to this Message

M.Siler - 15 Jun 2007 14:02 GMT

Yes, I was trying to get mixed colors within a single cell dependent on if
it was a number or letter. Oh, well... it was worth a shot.

> If you want digits and letters within one cell to have different colours I
> cannot help other than to suggest you experiment with different fonts.
[quoted text clipped - 12 lines]
>> Thanks,
>> Mark

Reply to this Message

Earl Kiosterud - 17 Jun 2007 15:31 GMT

Mark,

In my opinion, Bernard's suggestion to look for a font that more clearly displays the l and
1 characters is the best idea.

Signature

Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------

> If you want digits and letters within one cell to have different colours I cannot help
> other than to suggest you experiment with different fonts.
[quoted text clipped - 11 lines]
>> Thanks,
>> Mark

Reply to this Message

Ragdyer - 17 Jun 2007 15:42 GMT

<<<"This will also display the selected colour if you inadvertently press l
(lower case L) when you want 1 (digit 1)">>>

Bernard, how can a char(49) be mistaken for a char(108)?

Your suggestion of
=Istext(A1)
Works fine for me, or even the alternative:
=Isnumber(A1)

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> If you want digits and letters within one cell to have different colours I
> cannot help other than to suggest you experiment with different fonts.
[quoted text clipped - 11 lines]
> > Thanks,
> > Mark

Reply to this Message

Earl Kiosterud - 17 Jun 2007 15:25 GMT

I think you have mixed alpha and digits (not either all alpha or digits). In that case,
yes, you can have different colors, but only if the cell actually contains the data, not a
formula that yields it. It can't, in this case, be done with conditional formatting, but
can be done manually or via a macro. To do it manually, put the cell in edit mode
(double-click it or press F2 or click in the formula bar). Then select the characters you
want to change and use the text color button on the formatting toolbar to change the color.

Signature

> Is it possible to format a cell where numbers are one color and alpha is another? I'm
> using Excel 2007?
[quoted text clipped - 3 lines]
> Thanks,
> Mark

Reply to this Message

Rate this thread: