Forum Discussion
Alana_K
Jan 10, 2024Copper Contributor
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 ...
OliverScheurich
Jan 10, 2024Gold Contributor
=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).