Conditional formatting in an auto populated calendar

Copper Contributor

Alana_K_1-1704920904844.png

 

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:

=IF(AND(G$5>=$D6,G$5<=$E6),1,"")

 

1 Reply

@Alana_K 

=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).