|
-
Sep 21st, 2005, 09:56 AM
#1
Thread Starter
Member
[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.
-
Sep 21st, 2005, 11:35 AM
#2
Thread Starter
Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|