Conditional formatting problem

  • Thread starter Thread starter SueL
  • Start date Start date
S

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?
 
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.
 
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.
 
Back
Top