Originally Posted by Kevin@Radstock

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.

Originally Posted by Pecoflyer

Err, I don't think so...
To format F16 you select F16 not A16

OP asked for $F16 so the condition would be =$a16="y" ( guessing)

Of course with an example sheet it would have been MUCH easier