Forum Discussion
Conditional formatting in an auto populated calendar
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,"")
=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).
