Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel question

Comment:

question.. i have a current inventory spreadsheet running. And on the "current on hand" page i have the totals for each size/style of apparel we have. Is there anyway to flag a number if it falls below 100? Say if the total for style A shirt falls below 100 count, it will be highlighted or something?

Name: seawatch
Date: November 16, 2005 at 11:30:37 Pacific

Reply:

Use conditional formating. You can assign any value you want. So if the value is <100, the number changes to the color blue or something. Larry "Have no fear of perfection -- you'll never reach it." Salvadore Dali

0

Reply:

awesome that works great, thanks!

0

Name: seawatch
Date: November 16, 2005 at 13:24:30 Pacific

Reply:

You're welcome. Larry "Have no fear of perfection -- you'll never reach it." Salvadore Dali

0

! nETWORK pASSWORD !

Revert 2003 pst to 2000 p...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: P.S. It would be helpful if you could be more specific with your subject lines. If everyone who had an Excel question used a subject line as generic as Excel Question, searching the archives by subjec...

Summary: My question is regarding Microsoft Excel XP. One day I decided to e-mail my Excel folder and since then every time I open the file the pop-up appears asking me to log in to my Microsoft outlook. I wou...

Summary: Just a few questions about office XP 1. How do I insert an existing spreadsheet from Excel to PowerPoint instead of highlighting the spreadsheet and copy - paste into PowerPoint. 2. How do I link cell...