Let's say I have a table with rows ranking different fruits. I want to fill cells with "Apple" or "Pear" with green and cells with "Banana" or "Grape" with red. How do I use a formula in conditional formatting to accomplish this? I feel like I should be using the OR function, but I'm not sure.
Apple Orange Banana Pear Grape Orange Banana Apple Pear Grape Banana Orange Pear Apple Grape
Bookmarks