Conditional formatting - color change

I'm new to this VB programming stuff
OK. So I have one out of three (interior color) working. Can someone tell me why the Bold and Font colors don't change with the code I have???

Thanks for the help !

Please Login or Register  to view this content.

You do not set the isbold here...

Please Login or Register  to view this content.

You do not set the fcolor here...

Please Login or Register  to view this content.

If that's not the reason, then I have no idea what you're asking.

Thanks for the reply Ikaabod. Someone else pointed out my error. I didn't use Font.Colorindex to set the font color.

The lines you pointed out I did not want to modify the color.