View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CD01 CD01 is offline
external usenet poster
 
Posts: 4
Default 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