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
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Jun 9, 2011 at 12:42 AM
Related:
- Conditional formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Conditional formatting if cell contains text - Excel Forum
- Excel grade formula - Guide
3 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Jun 8, 2011 at 08:14 AM
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.
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, 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
Jun 9, 2011 at 12:42 AM
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
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
Jun 8, 2011 at 09:43 AM