Help - Conditional Formatting

[Chetansuri]

Condition 1 - If cell K is not blank:

1) cell A should show how many days diference from expiration date (cell B) to today
2) If between 95 - 91 color of Cell A should be green
3) If 90th day - color red
4) If cell P (dispatch Date) is not empty ie any date is shown the above 3 condition should not be satisfied

Condition 2 - If cell K is blank:

1) cell A should show how many days diference from expiration date (cell B) to today
2) If between 76 - 80 color of Cell A should be Blue
3) If 75th day - color Yellow
4) If cell P (dispatch Date) is not empty i.e. any date is shown the above 3 condition should not be satisfied


Thanks in advance for your help.

[etaf]

in A2 put
=B3-TODAY()
as that is the number of days - and seems to be the same calculation for all conditions


Use
GREEN
=AND(A3>=91,A3<=95,P3="",K3<>"")

YELLOW
=AND(A3=75,P3="",K3="")

BLUE
=AND(A3>=76,A3<=80,P3="",K3="")

RED
=AND(A3=90,P3="",K3<>"")

[Chetansuri]

Thank you... It worked....

[etaf]

excellent - i did not test thoroughly - you may want to do that for all possible combinations

if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved