View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arlen Arlen is offline
external usenet poster
 
Posts: 86
Default Reference a cell based on Fill color?

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