Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Rathji · 12-05-2009, 08:28 PM

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.

Select the area of the worksheet that contains the information you want to highlight.
On the Format menu, click Conditional Formatting.
In the box to the right of Cell Value Is, click the arrow, and in the drop-down list, click less than.
In the next box to the right, type 15.
Click Format.
Under Font style, click Bold. Then in the Color list, click the arrow and select the Red box.
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.

12-05-2009, 08:28 PM	#3
Rathji Franchise Player Join Date: Nov 2006 Location: Supporting Urban Sprawl Exp:	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. Select the area of the worksheet that contains the information you want to highlight. On the Format menu, click Conditional Formatting. In the box to the right of Cell Value Is, click the arrow, and in the drop-down list, click less than. In the next box to the right, type 15. Click Format. Under Font style, click Bold. Then in the Color list, click the arrow and select the Red box. 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. __________________ "Wake up, Luigi! The only time plumbers sleep on the job is when we're working by the hour." Last edited by Rathji; 12-05-2009 at 08:32 PM.