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?

Did you select all of row 2 first?

--
__________________________________
HTH

Bob

"SueL" wrote in message
...
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?

=a2="y"
--
Gary''s Student - gsnu200828

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?

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.

"Gary''s Student" wrote:

=a2="y"
--
Gary''s Student - gsnu200828

LOL! Didn't catch that!

--
__________________________________
HTH

Bob

"Gary''s Student" wrote in message
...
=a2="y"
--
Gary''s Student - gsnu200828