Conditional formatting problem

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?
 
W

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top