Results 1 to 2 of 2

Thread: [RESOLVED] Condition based on cell color

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2005
    Posts
    61

    Resolved [RESOLVED] Condition based on cell color

    I want to use an If statement based on whether or not the cell has been colored; I believe that it will look a little like this:

    If (cell has interior color = true) then
    Else
    End if

    But I am not sure what the code will be for asking VB to recognize whether the cell is colored or not.
    Also could you please provide me with other good online sources for answers to questions similar the inquiry above? This way I don't have to ask so many nubi questions like this one.

  2. #2

    Thread Starter
    Member
    Join Date
    Aug 2005
    Posts
    61

    Re: Condition based on cell color

    I am sorry the answer was previously given to me I just needed to put it together.

    If ActiveCell.Interior.ColorIndex = xlColorIndexNone then

    OR I could use

    If Not ActiveCell.Interior.ColorIndex = xlColorIndexNone then

    However, I would still like to get a hold of some recommended sources for VB code.

Posting Permissions

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



Click Here to Expand Forum to Full Width