Excel->Data->Validation Foruma Query

Hi,
I have got a requirement which is as folows:--
1)Suppose $A$2 can have three values:-- apple,orange,grapes.
If it has value as apple or grapes then validation should happen that $B$2 value should greater then zero.I need to implement it through Excel->data->validation.Please let me know how to create the formula for it.

2)Also how to extend it to all cells below it.I mean the formula should apply all cells below.like ($A$3-> $B$3) etc .($A$4-> $B$4) .etc

Regards,
Rahul

Hi,
I applied a data validation to a cell B5 through excel-data-validation.
When i enter data in B6, it doesnt fire.
How can I ensure that the same validation formula apples to all below cells.
The for,ula i am using is:--
=OR(E7="apple", 1<K7)

Regards,
Rahul

G'day and welcome to the forum,

Not clear on the goal(s) you need to meet. Please upload a zip example and we can go from there.


Cheers