I want to create conditional formatting that will change the font color to
"red" and "bold" if the date is after the current date. The current date is
always contained in cell A1. How do I do this using the conditional
formatting option?