Conditional formula

Solved/Closed
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,


Hi everyone,

Just want to seek for your help about some conditional formula about excel. I just want to create program about our inventory and marketing strategy. I want to create a formula in excel that can easily determine if movement/ withdrawal of product from our warehouse to our shop is fast or slow. Like for example below table

Product stocks
05/07 05/14 05/21 05/28
A 250 240 150 10
B 1000 100 0 0
C 250 250 250 240


For the product B, i need formal that can remind me like only (change in font color) that we received this item but in short time this items is sold out.

Hope is can make sense.

3 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
What are the condition in which you want the formating,
Kindly have a brief and link the same with data.
the condittion is in the qty stocks. If the stocks of the existing date is 80% lower than previous stocks. on that time, they can give me wanrning this that can ia easily see. Like for exmple is stocks of 05/7 is 1000 and then after a week is become 100..
the condittion is in the qty stocks. If the stocks of the existing date is 80% lower than previous stocks. on that time, the program can give me warnaing that we have no more enough stocks Like for exmple is stocks of 05/7 is 1000 and then after a week is become 100..
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Use Conditional Formatting.

assumption are:

1) first row is date header

2) First column have product no.

e.g. your data look like

05/07 05/14 05/21 05/28
A 250 240 150 10
B 1000 100 0 0
C 250 250 250 240.

select cell C2.

Go to conditional formatting.

use formatting by formula.

Write down formula as:

=C2<B2*0.8 for format your desired color. click enter

Now copy cell C2 and select your entire range.
Than right click - Paste Special - Format - Enter

Hope this solve your problem.

Regards,
Rahul