Conditional formatting in an auto populated calendar

Copper Contributor



I found this template online and it's almost exactly what I'm looking for however, I want the color coding to be determined by whatever is listed in the B column. Like for example if sale 1 is on Platform A, the boxes on the right should turn green. If it's on Platform B it should turn blue etc. Is this possible? 


Also for reference, this is the formula that determines what goes in the blocks to the right:



1 Reply


=AND(G$5>=$D6,G$5<=$E6,$B6="Platform A")

=AND(G$5>=$D6,G$5<=$E6,$B6="Platform B")


You can enter a rule for every different color. The first rule for conditional formatting would be for green (Platform A in column B) and the second rule for blue (Platform B in column B).