How to specify no color and white cell color?

February 20, 2011 at 06:54:24
Specs: Windows XP
I need an Excel 2007 macor or an If/Then statement that would determine if a cell has no color or the cell has a white color. For example, if A1 cell color is White or has No Color, return 0. If not, then return 1. I appreciate any help on this. Thanks, John Wayne.

See More: How to specify no color and white cell color?

Report •

#1
February 20, 2011 at 09:19:41
Before we tackle your question, let's make sure we understand what we are dealing with.

Are you asking about cells that have a specific Fill color chosen via Format Cells...Fill or are you asking about cells that been colored via Conditional Formatting?

Those 2 situations are handled very differently since VBA does not recognize a conditionally set color as a fill color.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question