conditional formatting -

[crave4excel]

Hello!
I'm hoping someone can advise me how to create a condition format for the following:

If the text of a certain cell equals to "apple", or "oranges", then the cell would be highlighted yellow. I've tried to use the "Use a formula to determine which cells to format", but i can't seem to get the OR formula to work.

Thank you!

 

[Gerald Higgins]

=or(a1="apples",a1="oranges")

 

[etaf]

use

or(cell="apples", cell="oranges")
where cell is the first cell in the range you are testing

What is the range of cells you want to conditional format and what is the cell

ie is it
A2 to A200
and the cell is in A2 onwards

 

[etaf]

Excel Workbook
	A
1	apples
2	oranges
3	lemons
4	fruit
5	oranges
6	lemons
7	fruit
8	apples
9	oranges
10	lemons
11	oranges
12	lemons
13	fruit
14	oranges
15	lemons
16	fruit
17	apples
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A2	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A3	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A4	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A5	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A6	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A7	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A8	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A9	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A10	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A11	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A12	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A13	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A14	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A15	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A16	1. / Formula is =OR(A1="apples", A1="oranges")	Abc
A17	1. / Formula is =OR(A1="apples", A1="oranges")	Abc