Automatically Changing Colors of Wingding Dots

Automatically Changing Colors of Wingding Dots

I currently manually insert large dots in certain cells in Column A of my
spreadsheet based on the contents of cells D67 or D68 and I would like to
automate the process.

If D67 contains a Checkmark (Char252) then I would like A1 to
contain a large BlackDot (Char108) colored Blue. If D68 contains
a Checkmark (Char252) then I would like A1 to contain a large
BlackDot (Char108) colored Red.

I add the Checkmarks in D67 or D68 and they change infrequently so
there would never be an instance when D67 and D68 both have a
Checkmark at the same time.

I don’t know where to start because I need to code the insertion of the
BlackDot (Char108) and then code the dot a certain color --- either
red or blue.

Help is always appreciated.