Change Cell colour

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
If cell D21 is greater than D25, I want D27 to go red. How do i write this,
please.

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

Format to Pattern of Red and OK


Gord Dibben MS Excel MVP
 
In D27, Format/ Conditional Formatting/ Formula Is: =D21>D25
then select your desired format
 
Gentlemen,

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

I am very grateful.
 
Back
Top