Hi

I want to create a project plan in Excel. For the progress bar, I am using the Webdings format and the characters "c" for a blank cell and "g" for an active cell however I need to change the colour of the "c" to white and the "g" to black.

I have calculated 3 text strings based on the time until the activity starts, the duration of the activity and time after that until the project ends. These strings are "cccc", "gg", "cc" which I then add together using the formula =a1&a2&a3 which gives "ccccggcc". Using Webdings this then gives me 4 blanks, 2 filled squared and 2 blanks so would show that we have 4 weeks until the activity starts and it lasts for 2 weeks.

However the "c" character shows up as an outlined box and I would like to change the format of that to font colour white. So the string would become "ccccggcc"

I've searched the web and it seems that I need to create a module to do this but that's me out of my depth!

Any ideas how I go about doing that?

Thanks