gogumakilla
New Member
- Joined
- Jun 28, 2016
- Messages
- 6
I have grouping of cells (apples, oranges, or bananas) in column A that I want to highlight ONLY IF all of the corresponding cells in column B say "Active" for that particular fruit grouping. IE the apple and bananas grouping would not be highlighted because they have both the "Active" and "Inactive" values in their grouping. The Oranges grouping is highlighted because all of its corresponding cells in column B says "Active". Is there a formula that can do this?
I probably explained this poorly but any help would be greatly appreciated, thanks.
I probably explained this poorly but any help would be greatly appreciated, thanks.