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?

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?

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?