Excel - Can I change text colour according to the letter entered?

Hello,

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

Cheers
Lindzl




--
LindzlBunzl

LindzlBunzl;1604267 Wrote:

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




--
Spencer101