Quote:
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.
|
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