Hi Sue,

Because the y is text it may work if you put an "y" before and after the
letter like =A2="y".
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


"SueL" wrote:

I'm trying to use Conditional Formatting to highlight a row using an if
formula.
eg
if a2=y then make row bold.

I've followed the various tutorials online and selected the range I wish to
apply the CF to, selected new rule, used the formula option, entered =$a2=y
in the formula box and changed the formatting to bold, but nada, the
formatting doesn't change at all.

Anyone got any ideas?