lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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.
Last edited: