Use a formula to apply conditional formatting - Office Support

The first rule, in column A, formats future birthdays, and the rule in column C ... see if the cells in column C contain “Y” (the quotation marks around the Y tell Excel ... Set a color format to be applied to cells that match the criteria (that is, there

support.office.com