Conditional formatting problem

[SueL]

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?

 

[Bob Phillips]

Did you select all of row 2 first?

 

[Gary''s Student]

=a2="y"

 

[Warren Easton]

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]

Thanks Gary
I'd used single quote marks but had forgotten that I needed to use double
quotes. It's been a while since I've used text formulas in Excel.

 

[Bob Phillips]

LOL! Didn't catch that!