Calendar challenge conditional formatting colour

Hey excel friends

I have made a calendar in excel. depending in the dates it coulors a spot in the calender to create an overview. Currently i coulors everything orange, However i need to colour to change depending on a "fruit". Its hard to explain, but please feel free to check the example

try these in CF..

=AND(F1>=1,F1<=3,$C7="Apple") --format red

=AND(F1>=1,F1<=3,$C7="Orange") --- format orange

=AND(F1>=1,F1<=3,$C7="Banana") --- format yellow

And so on..

Copy and paste special --formats down and across