Use a formula to apply conditional formatting - Excel - Office - Microsoft

Use formulas in conditional formatting to do more than you can with the built-in rules. ... In the Color box, select Red. ... 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

office.microsoft.com