Can anyone tell me what the purpose of xlAutomatic is for in Font Color? I've scripted some code that allow a user to change the cell background color. My trouble is when the user chooses "Black", then the font doesn't show. I was hoping that "Automatic" meant that it would turn to white so that text was visible. Wrong! Is there anyway to accomplish this without writing specific code for dark colors? thanks,
Bookmarks