highlight blank cells then enter text/num in color

[lezawang]

Hi
I want to highlight blank cells. So I highlighted my range and then went to Find->Special->blank. Excel highlight them for me. Then I enter 0 in the active cell and changed the color to red then pressed CTRL+Enter. 0 was entered on all cells but the color of the font changed to black for all cells including the one which was the active. Why 0 in red did not populated? I was hoping to see red 0 in all blank cells. Thank you.

 

[Fluff]

Change the font colour, then enter 0