software

I am color blind (to same extent). Sometimes I need to determine what is cell
(or font) color in an existing worksheet. I would like to be able to
right-click on a cell and see what is its background color. Or right-click on
a letter/digit in a cell and see what is font color and background color. I
assume that does NOT exist now. How can I deliver my request to the Excel
development group?

If you respond, PLEASE notify me at

Thanks
NaumAdd this sub

Sub ColorIndex()
Dim msg As String

If Selection.Cells.Count gt; 1 Then
MsgBox quot;Too many cells selectedquot;, vbExclamation, quot;ColorIndexquot;
Else
MsgBox quot;Active cell colour is quot; amp; ActiveCell.Interior.ColorIndex,
vbInformation, quot;ColorIndexquot;
End If
End Sub

Then create a right-click menu option with

'-----------------------------------------------------------------
Private Sub Workbook_Open()
'-----------------------------------------------------------------
With Application.CommandBars(quot;Cellquot;)
With .Controls.Add(Type:=msoControlButton, temporary:=True)
.Caption = quot;Colorquot;
.BeginGroup = True
.Style = msoButtonCaption
.OnAction = quot;ColorIndexquot;
End With
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Naumquot; gt; wrote in message
...
gt; I am color blind (to same extent). Sometimes I need to determine what is
cell
gt; (or font) color in an existing worksheet. I would like to be able to
gt; right-click on a cell and see what is its background color. Or right-click
on
gt; a letter/digit in a cell and see what is font color and background color.
I
gt; assume that does NOT exist now. How can I deliver my request to the Excel
gt; development group?
gt;
gt; If you respond, PLEASE notify me at
gt;
gt; Thanks
gt; Naum
gt;
How many color blind Excel users are there out there?
It's conceivable that someone might take it on themselves to
write an Excel add-in, to identify colors (by index and name), and give it away.
But there would have to be some indication that demand exists.
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;Naumquot; gt;
wrote in message
I am color blind (to same extent). Sometimes I need to determine what is cell
(or font) color in an existing worksheet. I would like to be able to
right-click on a cell and see what is its background color. Or right-click on
a letter/digit in a cell and see what is font color and background color. I
assume that does NOT exist now. How can I deliver my request to the Excel
development group?
If you respond, PLEASE notify me at
Thanks
NaumNo demand at all has appeared. But not being deterred by facts
when you want to do something, I have written an Excel add-in that
might help some Excel users.
It adds a menu item to the popup menu that appears when a cell
is right-clicked. The menu lists the cell color, font color and cell location.

If anyone would like to try the add-in and provide any comments or
suggestions about it, my email is: XX
(remove xxx from the address)
--
Jim Cone
San Francisco, USA
www.officeletter.com/blink/specialsort.html
quot;Jim Conequot; gt; wrote in message ...
How many color blind Excel users are there out there?
It's conceivable that someone might take it on themselves to
write an Excel add-in, to identify colors (by index and name), and give it away.
But there would have to be some indication that demand exists.
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftware
quot;Naumquot; gt;
wrote in message
I am color blind (to same extent). Sometimes I need to determine what is cell
(or font) color in an existing worksheet. I would like to be able to
right-click on a cell and see what is its background color. Or right-click on
a letter/digit in a cell and see what is font color and background color. I
assume that does NOT exist now. How can I deliver my request to the Excel
development group?
If you respond, PLEASE notify me at
Thanks
Naum