some of the color palletes in excel do not show there name when I.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

some time I have to color certain item(s) in a certain color, but when I put
the arrow on the color pallete, in Excel it does not identifies the color
name and since many of the colors look similar than how do I know that I
chose the correct one.

I also can not find the cent symbol. Example--99cents

please advice me

Thank You BYE
 
Hi

can't help you with the color pallete question
but (as far as i know) there is no cents symbol, generally people enter 99c
as $0.99
however, if you really want the c to show up after numbers (and be warned
this does not affect calculation in any way - just how it appears on the
screen) you can make a custom number format.

click on the cell that you want the "c" to appear behind the numbers and
choose format / cell - one the number tab, click on custom and then on the
white line to the right you'll see something like the word GENERAL type "c"
directly after it, ie
GENERAL"c"
and click OK


Hope this helps
Cheers
JulieD
 
The cents sign is CHAR(162) - ¢ -
So, do Custom Format
And after "General" type:
<Alt> 0162
Using the num keypad, *not* the numbers under the function keys.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi

can't help you with the color pallete question
but (as far as i know) there is no cents symbol, generally people enter 99c
as $0.99
however, if you really want the c to show up after numbers (and be warned
this does not affect calculation in any way - just how it appears on the
screen) you can make a custom number format.

click on the cell that you want the "c" to appear behind the numbers and
choose format / cell - one the number tab, click on custom and then on the
white line to the right you'll see something like the word GENERAL type "c"
directly after it, ie
GENERAL"c"
and click OK


Hope this helps
Cheers
JulieD
 
Hi RD

handy to know

cheers
JulieD

RagDyeR said:
The cents sign is CHAR(162) - ¢ -
So, do Custom Format
And after "General" type:
<Alt> 0162
Using the num keypad, *not* the numbers under the function keys.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi

can't help you with the color pallete question
but (as far as i know) there is no cents symbol, generally people enter
99c
as $0.99
however, if you really want the c to show up after numbers (and be warned
this does not affect calculation in any way - just how it appears on the
screen) you can make a custom number format.

click on the cell that you want the "c" to appear behind the numbers and
choose format / cell - one the number tab, click on custom and then on the
white line to the right you'll see something like the word GENERAL type
"c"
directly after it, ie
GENERAL"c"
and click OK


Hope this helps
Cheers
JulieD
Click to expand...
 
As far as the colors go....you can use the cellcolorindex UDF from Chip
Pearson's site.

Function CellColorIndex(inRange As Range, Optional _
OfText As Boolean = False) As Integer
'
' This function returns the ColorIndex value of a the Interior
' (background) of a cell, or, if OfText is true, of the Font in the cell.
'
Application.Volatile True
If OfText = True Then
CellColorIndex = inRange.Font.ColorIndex
Else
CellColorIndex = inRange.Interior.ColorIndex
End If
End Function

Use it to determine the exact colorindex of a cell so's you can replicate it.

You can also run this macro to get a listing of the colorindices on a new
worksheet.

Sub ListColorIndexes()
Dim Ndx As Long
Sheets.Add
For Ndx = 1 To 56
Cells(Ndx, 1).Interior.ColorIndex = Ndx
Cells(Ndx, 2).Value = Hex(ThisWorkbook.Colors(Ndx))
Cells(Ndx, 3).Value = Ndx
Next Ndx
End Sub

Gord Dibben Excel MVP
 
Yes, you can with newer versions of Excel.

The older ones, XL97 for sure, did not have the Insert>Symbol feature.

Gord Dibben Excel MVP
 
Back
Top