Conditional Format Formula Issue for Coloring Cell

[KuraiChikara]

Hello,
I don't use the "use a formula to determine which cells to format" functionality much in Conditional Formatting in Excel but I have a problem where it will help me.

Issue:
I think my problem is relatively simple but I don't know how to do it.
In cell A1 there is a word, say "Apples" and whatever name is put in cell B1, if A1 has the word "Apples" in it, then B1 would be highlighted RED.

Subsequently, if I changed the fruit in A1 to something else, I would eventually want to assign different colours to them which would be reflected in B1 IE: Bananas in A1= a B1 highlight to YELLOW, Pears in A1 = a B1 highlight to GREEN.

 

[jtakw]

Hi,

Use the same formula for each condition and color, change Apples to Bananas, Pears, Oranges or whatever you need:

Book3.xlsx
	A	B
6	some apples
Sheet829

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6	Expression	=COUNTIF(A6,"*apples*")	text	NO

 

[KuraiChikara]

Thank you very much. This works just fine.

 

[jtakw]

You're welcome, thanks for the feedback.