Conditional number format based on the text of another field

[AKAvenger]

Hi Guru's

Need some help on a conditional format.

I have two columns, A = "Fruit Names" and another B = "Value" in which a value can be entered manually.

I need column B number format to change as follows:

If column A "Fruit Names" = "Apple", "Banana", "Peach" then number format in column B "Value" should be % BUT, if column A "Fruit Names" = "Pears" or "Watermelon" then column B "Value" should be number.

I have tried, but only succeed if there is one condition, I don't know how to do this with multiple conditions.

 

[Fluff]

Format the column as Number and then in CF use

=or(A2="Apples",A2="Banana",A2="Peach")

and set the format for %

 

[AKAvenger]

Format the column as Number and then in CF use

=or(A2="Apples",A2="Banana",A2="Peach")

and set the format for %

Perfect, thank you so much. Worked great!

 

[Fluff]

You're welcome & thanks for the feedback.