Change Cell colour
 

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

Use Conditional Formatting from the Format menu. It will allow you to do
exactly what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"CD01" wrote in message
...
I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

Use in the Format menu - Condiotional formating

"CD01" wrote:

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

Assuming your min stock level in B1 and actual stock in A1
Conditional Formatting
Formula Is: =$A$1<$B$1
format any color you like

"CD01" wrote:

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

If cell D21 is greater than D25, I want D27 to go red. How do i write this,
please.

Thank you.

"Joel" wrote:

Use in the Format menu - Condiotional formating

"CD01" wrote:

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

Select D27 and FormatCFFormula is: =D21D25

Format to Pattern of Red and OK


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 10:10:21 -0800, CD01 wrote:

If cell D21 is greater than D25, I want D27 to go red. How do i write this,
please.

Thank you.

"Joel" wrote:

Use in the Format menu - Condiotional formating

"CD01" wrote:

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

In D27, Format/ Conditional Formatting/ Formula Is: =D21D25
then select your desired format
--
David Biddulph

"CD01" wrote in message
...
If cell D21 is greater than D25, I want D27 to go red. How do i write
this,
please.

Thank you.

"Joel" wrote:

Use in the Format menu - Condiotional formating

"CD01" wrote:

I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that
when
my actual stock is less than this value the cell background colour
changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD

Change Cell colour
 

Gentlemen,

Thank you very much indeed for your generous and useful help.

I am very grateful.


"Chip Pearson" wrote:

Use Conditional Formatting from the Format menu. It will allow you to do
exactly what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"CD01" wrote in message
...
I use 2003 Excel to maintain stock levels in my inventory.

What I would like to do is set a min stock level and use that so that when
my actual stock is less than this value the cell background colour changes
from no colour to say, red so I can see it quickly.

Can this be done? If so, please tell me how.

Thank you,

CD