i have cell B12 that i want to score through the text if todays date is equal
to or has passed from A12. i know about the conditional formating control but
if i check the date in A12 i want the answer to cause B12 to change?

Thanks in advance
Arnie