Conditional formatting matching more than one criteria

[Ira Hopkins]

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

Category	Blah	Blah	Date	name
Bread	Blah	Blah	31-Jul-18	Jones
Bread	Blah	Blah	31-Jul-18	Thomas
Biscuit	Blah	Blah	31-Jul-18	Hughes
Bread	Blah	Blah	31-Jul-18	Smith
Cake	Blah	Blah	31-Jul-18	Gordon
Cake	Blah	Blah	31-Jul-18	Carter
Bread	Blah	Blah	31-Jul-18	Hall
Bread	Blah	Blah	31-Jul-18	Williams
Biscuit	Blah	Blah	31-Jul-18	Jones
Bread	Blah	Blah	31-Jul-18	Thomas
Doughnut	Blah	Blah	31-Jul-18	Hughes
Bread	Blah	Blah	31-Jul-18	Smith
Biscuit	Blah	Blah	31-Jul-18	Gordon
Bread	Blah	Blah	31-Jul-18	Carter
Biscuit	Blah	Blah	31-Jul-18	Hall
Cake	Blah	Blah	31-Jul-18	Williams
Doughnut	Blah	Blah	20-Jul-18	Jones
Doughnut	Blah	Blah	31-Jul-18	Thomas
Bread	Blah	Blah	31-Jul-18	Hughes
Bread	Blah	Blah	31-Jul-18	Smith
Bread	Blah	Blah	31-Jul-18	Gordon
Doughnut	Blah	Blah	31-Jul-18	Carter
Bread	Blah	Blah	31-Jul-18	Hall
Cake	Blah	Blah	31-Jul-18	Williams
Doughnut	Blah	Blah	31-Jul-18	Jones
Bread	Blah	Blah	31-Jul-18	Thomas
Bread	Blah	Blah	31-Jul-18	Hughes
Doughnut	Blah	Blah	31-Jul-18	Smith
Bread	Blah	Blah	31-Jul-18	Gordon

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>