Ira Hopkins
New Member
- Joined
- Apr 8, 2019
- Messages
- 25
Hi All I have been struggling with this one. I can do it if its a duplicate but not with different criteria. Basically I need to get a formula, preferably using conditional format ( so it colours the rows) I want it highlighting if as example Mr Jones had bread, doughnuts, and cake in the same month, but sometimes mr jones might have biscuits and bread in the same month ( would like different colour for each criteria) Is this impossible? I can do certain aspects of it but when I try and do it all together it doesn't work- example below- Thanks so much for your time
[TABLE="width: 377"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD]Date[/TD]
[TD]name[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]20-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 377"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD]Date[/TD]
[TD]name[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Biscuit[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]20-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Carter[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Cake[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Williams[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Jones[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Thomas[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Hughes[/TD]
[/TR]
[TR]
[TD]Doughnut[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Smith[/TD]
[/TR]
[TR]
[TD]Bread[/TD]
[TD]Blah[/TD]
[TD]Blah[/TD]
[TD="align: right"]31-Jul-18[/TD]
[TD]Gordon[/TD]
[/TR]
</tbody>[/TABLE]