Excel Noob Here! Need Help!

[flamestalker]

Hey guys, I couldn't find out how to do this, but is there anyway you can select a range of numbers within a column of data (ex. >4) and highlight them a certain colour to make it easier to view?

Thanks.

[Drury18]

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.

[Rathji]

in Excel 2003, from the Office Site,
Use conditional formatting

Use conditional formatting to make certain values jump right out at you when conditions are right, making it easy to see what you're looking for. For example, you might want numbers less than 15 to be formatted in bold red text.

1. Select the area of the worksheet that contains the information you want to highlight.
2. On the Format menu, click Conditional Formatting.
3. In the box to the right of Cell Value Is, click the arrow, and in the drop-down list, click less than.
4. In the next box to the right, type 15.
5. Click Format.
6. Under Font style, click Bold. Then in the Color list, click the arrow and select the Red box.
7. Click OK twice.

If you are interested in learning more, there is a complete set of tutorials that I used when I switched to supporting Office 2003, located here. Some of it was pretty simple, but at the end of each section they have a quick reference card that I use to recall anything I don't use all the time.

[flamestalker]

Thanks for the quick responses guys. Got it figured out.