Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Hamburg, Germany
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Colored cells (excel2000)

    Hi all I need help,
    I have a column of cells that contains text. Some of data are marked by coloring the cell differently. How can I identify colored cells by creating a macro? I read the help files try to find something about cells property, but I can't find anything.

    Thanks,
    Yudi

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Colored cells (excel2000)

    Hi Yudi

    Check functions for working with cell colors by Chip Pearson.

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Location
    Hamburg, Germany
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Colored cells (excel2000)

    Hi Tony,
    The link you have given to me is great. It answers all my problems.
    Many thanks,
    Yudi <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Colored cells (excel2000)

    Hi Yudi, glad to be of help & welcome to the Lounge.

    If only 1 link could answer all of my problems. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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