Chaniging cells font colour after using command button

[ncaravela]

Hi again,

Can anyone help with the vba code to do as follow:

If the white cells are filled than, after pressing the command button, the blue cells turn the font text color to black.

Please see the attached file.

Thanks.

[Mumps1]

Do all of the white cells need to have data or just some of them? What do you mean by

the blue cells turn the font text color to black

Could you please be more specific?