Hi

Select cell A16 > Home Tab > Conditional Formatting > New Rule > Select - Use a formula to determine which cell to format. In the "Format values where this formula is true:" type the following "=$A$16="Y", click format button and apply your format preference.