Might be simple... Cell Formating.

  • Thread starter Thread starter M.Siler
  • Start date Start date
M

M.Siler

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
 
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
 
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.
 
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.

--
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...
 
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.

--
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...
-----------------------------------------------------------------------
 
<<<"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)
 
Back
Top