You could try Cell("color",cell_ref)
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Arlen" wrote:

Is it possible to check if a cell has a fill color, preferably with an If
statement rather than a macro, but either way...

If not, is it possible to check if a cell has two "/", rather than just one?

Or even worse, how do you take the text string (it was typed in as text):
Sun 01/15/07 (but sometimes Sun 1/22/2007) and convert that to a numerical
date which can then have the month extrapolated?

I thank you in advance.

Arlen