Quote:
Originally Posted by LindzlBunzl
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 can't seem to find anything!
Cheers
Lindzl
|
Conditional Formatting is what you need.
Post an example workbook and I'll show you how, but it's easy enough to work out by googling it and working through an example or two.