Question about making calendar with VBA

[simoandr]

I can't figure out a way to use VBA to show multiple events on one day in my calendar. Currently, I have it programmed that when a new event is created the border or fill of the cell will change to correspond to the event type in my key. But I would like to be able to overlap the formatting, or maybe make the cell a neutral gray color, to indicate multiple events on one day.

Anyone have an idea about how I can do this?

[royUK]

Why VBA? You could use Conditional formatting

[simoandr]

Conditional formatting won't work since it's not based on values, it's based on the cell's format.

There must be a program I can write that establishes a rule that any cell changing from a non white background, non black border cell (a typical excel calendar cell) to another non white background, non black border cell simply becomes all gray or something.

Maybe an IF THEN function? Can anyone help?