KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
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.
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.