Quote Originally Posted by FrankBoston
The VBA solution would be to have a sub search the range of dates, check each one for expiration, and set the font color to blue or red. You probably wouldn't use Conditional Formatting.

I suppose you could use a sub to assign the conditional format to the rectangle of date cells.

Or, you can Edit: Copy: Paste - Formats (includes conditional formats) to the range holding the dates.

Why is your preference for VBA in this case?

Mainly because I am trying to gear towards VBA and the more I learn the better, I am trying to do everything using VBA....just to have a programming experience I suppose.