Your date conditional formatting is not working, perhaps because of the following reasons: • The supplied dates are invalid. • The supplied date values appear as dates, but they are text values. • The date formatting condition or rule specified in the New Formatting Rule window is incorrect.