interior color of a cell

R.VENKATARAMAN · 11-10-2005, 04:25 AM

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

Toppers · 11-10-2005, 04:55 AM

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.

"R.VENKATARAMAN" wrote:

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

**Leith Ross** · 11-10-2005, 07:14 AM

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

Tom Ogilvy · 11-10-2005, 08:30 AM

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

--
Regards,
Tom Ogilvy

"Leith Ross" <[email protected]> wrote
in message news:[email protected]...
>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=483839
>

**Leith Ross** · 11-10-2005, 09:43 AM

Hi Tom,

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

Thanks for your help,
Leith Ross

Tom Ogilvy · 11-10-2005, 10:10 AM

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

"Leith Ross" <[email protected]> wrote
in message news:[email protected]...
>
> Hi Tom,
>
> I wasn't aware of that, thanks. Where could I post it so the OP could
> download the file?
>
> Thanks for your help,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=483839
>

**davidm** · 11-10-2005, 12:02 PM

Venka must be having my problem of failing to distinguish between some fine shades of color (light green/light yellow in my case).

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

David

GregR · 11-10-2005, 01:00 PM

Leith, imported the BAS file and the FRM file. What do I do with the
FRX file? TIA

Greg

R.VENKATARAMAN · 11-11-2005, 01:10 AM

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

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> Since R. VENKATARAMAN is not posting in the Excel Forum, he will not be
able
> to access your attachment.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Leith Ross" <[email protected]>
wrote
> in message news:[email protected]...
> >
> > 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 |
> > +-------------------------------------------------------------------+
> >
> > --
> > Leith Ross
> > ------------------------------------------------------------------------
> > Leith Ross's Profile:
> http://www.excelforum.com/member.php...o&userid=18465
> > View this thread:
http://www.excelforum.com/showthread...hreadid=483839
> >
>
>

R.VENKATARAMAN · 11-11-2005, 01:10 AM

thank you. It is a pleasure and educative to participate in newsgroups like
this

"Tom Ogilvy" <[email protected]> wrote in message
news:#[email protected]...
> 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
>
>
>
>
> "Leith Ross" <[email protected]>
wrote
> in message news:[email protected]...
> >
> > Hi Tom,
> >
> > I wasn't aware of that, thanks. Where could I post it so the OP could
> > download the file?
> >
> > Thanks for your help,
> > Leith Ross
> >
> >
> > --
> > Leith Ross
> > ------------------------------------------------------------------------
> > Leith Ross's Profile:
> http://www.excelforum.com/member.php...o&userid=18465
> > View this thread:
http://www.excelforum.com/showthread...hreadid=483839
> >
>
>