Change Cell colour

[Guest]

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

 

[Chip Pearson]

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)

 

[Guest]

Use in the Format menu - Condiotional formating

 

[Guest]

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

 

[Guest]

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

Thank you.

 

[Gord Dibben]

Select D27 and Format>CF>Formula is: =D21>D25

Format to Pattern of Red and OK


Gord Dibben MS Excel MVP

 

[David Biddulph]

In D27, Format/ Conditional Formatting/ Formula Is: =D21>D25
then select your desired format

 

[Guest]

Gentlemen,

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

I am very grateful.