Flagging Up Stock On Excel 2000

[Tom1988]

Hi
In my place of work i am stock controller.
I enter the stock levels into Excel 200 i was wondering if there is a way to
flag up the cell if stock fall below a certain level and if there is how to
do this?

 

[Roger Govier]

Hi Tom

On another sheet set yourself up a list of Stock items in column A and their
Min levels in column B.
Select this complete range of data, and in the Name box type MinStock and
press Enter.

On your Stock sheet, assuming the stock title is in column A, select the
range where Stock numbers are entered>Format>Conditional Formatting> select
Formula Is from dropdown>
=$A1<VLOOKUP($A1,Minstock,2,0)>Format>choose whatever you want.

 

[Chip Pearson]

You can use Conditional Formatting (on the Format menu) to do this.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)