Use a formula to apply conditional formatting - Support

The formula tests to see if the cells in column C contain “Y” (the quotation marks around the Y tell Excel that this is text). If so, the cells are formatted. In the Color ...

support.office.com