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?