Flagging Up Stock On Excel 2000
 

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?

Flagging Up Stock On Excel 2000
 

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 enteredFormatConditional Formatting select
Formula Is from dropdown
=$A1<VLOOKUP($A1,Minstock,2,0)Formatchoose whatever you want.

--
Regards
Roger Govier

"Tom1988" wrote in message
...
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?

Flagging Up Stock On Excel 2000
 

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)


On Tue, 10 Feb 2009 04:21:02 -0800, Tom1988
wrote:

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?