26 Mar 2014 Step 2: Open the Conditional Formatting dialog. Click "Save rules" when you're done. them to be differently colored when approaching (today) date and after. the formatting to ignore and just format based on date and month. is 01/27/2014 this would put the child at approximately 24 months old .