Can I change text colour according to the letter entered?

[LindzlBunzl]

Hello,

I only have a vague awareness of formatting and am quite new to th
whole Excel thing. I have created a spreadsheet for work on which
have a column which users will enter 'Y' or 'N' into. Is there anywa
that when the 'y' is entered that the test would go red and bold?
have tried searching various forums for help but can't seem to fin
anything!

Cheers
Lindz

 

[Spencer101]

Hello,

I only have a vague awareness of formatting and am quite new to th
whole Excel thing. I have created a spreadsheet for work on which
have a column which users will enter 'Y' or 'N' into. Is there anywa
that when the 'y' is entered that the test would go red and bold?
have tried searching various forums for help but can't seem to fin
anything!

Cheers
Lindzl

Conditional Formatting is what you need.
Post an example workbook and I'll show you how, but it's easy enough t
work out by googling it and working through an example or two