Apparently, that only works for conditional formatting, if cell text is
colored when it's a negative value.
"M Kan" wrote:
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