Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Color property doesn't set ANY color

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    To change the color of a cell (say, foreground) I use the "Color" or "ColorIndex" property of Range.Interior.Font. Now, I am telling about the "Color" property only. When I set this color (with rgb() function or a Hex value or a Long decimal value) I found that I could not set whatever color I wanted. I was able to set only few colors (which the "ColorIndex" property only allows). But I want to any of the available 256*256*256 colors. Am I going wrong. Is there any means to set any color?

    [ This Message was edited by: Prosenjit Banerjee on 2002-04-09 23:09 ]

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Belgium
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello,

    I am not sure of what I say, but are you sure your monitor supports all those colors that you want to use (with right click on the desktop / preferences)?

    Otherwise, the only thing I can think about is that your code is not completely correct.
    Cells(1, 1).Font.Color = RGB(0, 255, 0)
    Cells(1, 1).Interior.Color = RGB(0, 255, 0)
    is the right coding.

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear paludgnp,

    It was only my fault that I could not be able to make you understand my problem. From the very begining (the subject of this post) I have misguided you. It was "Color property doesn't set ANY color". I wanted to emphasize on the word "ANY" but it got in gain. Actucally the "Color" property certainly allows to set some colors. But it allows to select "ONLY SOME SELECTED COLORS" and these are the colors offered by "ColorIndex" property. To understand what I want to tell you just do as follows:

    (1) Go go Windows Paint.
    (2) Choose any color by clicking on the color palette and the choose "Colors->Edit Colors..." menu. Then edit the color by selecting "Define Custom Colors>>" and the by setting the Red, Green and Blue values as 68, 127, 187 respectively.
    (3) Have a look at the color.
    (4) Now go to excel.
    (5) Select any cell and write anything there.
    (6) Make the font big and bold so that its color is very easily viewable.
    (7) Go to VBE (ALT+F11) and then go to the Debug window (CTRL+G).
    (8) Type -> ActiveCell.Font.Color = RGB(68, 127, 187)
    (9) Now return back to the main Excel window and look at the color of the text in the selected cell.
    (10) Now you cannot match this color from the Paint's color created earlier and THAT IS THE PROBLEM.

    I think now you can understand my problem clearly. Please help me.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •