# Conditional formula

Solved/Closed
marvs - Jun 8, 2011 at 07:14 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jun 9, 2011 at 12:42 AM
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

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 8, 2011 at 08:14 AM
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..
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Jun 9, 2011 at 12:42 AM
Use Conditional Formatting.

assumption are:

1) first row is date header

2) First column have product no.

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