Yea. Although the instructions depend on the verison of Excel you have.
If you have 2007:
Highlight all the numbers of the column
Select "Conditional Formatting" from the Home/Styles portion of the toolbar (should be the toolbar that shows up automatically on setup unless you've changed the settings)
Select "Highlight Cell Rules"
Select "Less Then" (or Greater Then if the case)
Enter the number you want to be the Less Then/Greater Then mark
Select what fill/text/border you want from the drop down box.
|