interior color of a cell

  • Thread starter Thread starter R.VENKATARAMAN
  • Start date Start date
R

R.VENKATARAMAN

I searched in googles groups search I could not get satisfactory answer.

in the inermediate window if I type

activecell.inteiro.colorindex=3 the cell turns red (i.e filled with red
color)

in the same window if I type

?activecell.interior.colorindex
it gives result as
46

In a sub If I use a statement
if activecell.interior.colorindex=3 then -------------
it does not receognise that the cell color is red

But if I type
if activecell.interior.colorindex=46 then -------
it works.

clarifications sought. thanks
 
Hi,
Colorindex=3 is RED, colorindex=46 is ORANGE (but they look very
similar) so it will be worthchecking the activecell is really what you think
it is..

I did your tests and found no problem.
 
Hello R.VENKATARAMAN,

Toppers' post makes a good point. Sometimes it is difficult to tell the
difference between colors when you are shifting from one then to the
other. I created a VBA form that will display both the ColorIndex
number and the Color on individual buttons. If you can't read a button
because of the color, click it and you will see the number. This helps
in picking the right color you want to use.

Download the attached file, UnZip it, and import the User Form and
macro Module into your program using the VBA editor.

Sincerely.
Leith Ross


+-------------------------------------------------------------------+
|Filename: Show_Color_Index_Chart.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4026 |
+-------------------------------------------------------------------+
 
Since R. VENKATARAMAN is not posting in the Excel Forum, he will not be able
to access your attachment.
 
Hi Tom,

I wasn't aware of that, thanks. Where could I post it so the OP coul
download the file?

Thanks for your help,
Leith Ros
 
Well, he could use the thread link at the bottom to go to the Excel forum,
then he can access the attachment from your posting in the Excel forum.
Guess I should have said that in the original post - sorry.
 
Venka must be having my problem of failing to distinguish between som
fine shades of color (light green/light yellow in my case).

Coming to that, some of us are not much favored by the overly ornat
decor used in EXCEL 2003. I'd rather the old grey in earlier version
of EXCEL.

Davi
 
understood . I think I am a subscriber to excel forum also. shall try
there.


Tom Ogilvy said:
Since R. VENKATARAMAN is not posting in the Excel Forum, he will not be able
to access your attachment.

--
Regards,
Tom Ogilvy


in message news:[email protected]...
Click to expand...
 
thank you. It is a pleasure and educative to participate in newsgroups like
this


Tom Ogilvy said:
Well, he could use the thread link at the bottom to go to the Excel forum,
then he can access the attachment from your posting in the Excel forum.
Guess I should have said that in the original post - sorry.

--
Regards,
Tom Ogilvy




in message news:[email protected]...
Click to expand...
 
Back
Top