Conditional formatting help

[thebenjames]

I've written the below which shades days on a calendar in grey, depending on whether the days fall within the "Start" and "End" range, however I would ideally like it to be different colours depending on who is in the "Assigned To" column e.g. light grey if it's "FACULTY", dark grey if it's "CAT"

=AND(F$5>=$D8,F$5<=$E8)

For some reason I cannot get this to work; any ideas?

 

[thebenjames]

This is what I've got in the rule manager (I've also written one which shades those areas in green, relative to what is in the "PROGRESS" column, but this is working fine)

 

[bebo021999]

For light grey:
=AND(F$5>=$D8,F$5<=$E8,$B8="FACULTY")
For dark grey:
=AND(F$5>=$D8,F$5<=$E8,$B8="CAT")

 

[thebenjames]

For light grey:
=AND(F$5>=$D8,F$5<=$E8,$B8="FACULTY")
For dark grey:
=AND(F$5>=$D8,F$5<=$E8,$B8="CAT")

Thank you! I was having an absolute mare with this one