need a formula or conditional format:
if cell a1 has text, then apply the color RED to cells underneath say a2-a15.
then, once numbers are inserted in the cells a2, a3, a4, etc, those cells keep the numbers but turn the cells back to no fill or white.
I don't want you to feel like you are a bother, because you are not! I just need to understand you, before I can help.
Since you put the word button in quotes, I'm assuming you are not familiar with it.
To create a button you will need the Developers ribbon.
1.When it is not visible, right-click any other ribbon tittle, for example Start.
2.Choose to adjust the ribbon.
3.On the window that pops up, find the Developers check box in the right side window and check it.
4. Click OK.
5. On the Developer ribbon click on Insert.
6. The small popup is divided in 2 parts: Form (top) and ActiveX (bottom).
7. In the ActiveX part find the Command button (top left).
8. Once you click it, you can draw your button. Holding ALT while doing so will allow your button to match the cells grid.
9. Right click your button and select properties.
10. Here you can adjust your button. The ones I change are usually: BackColor (change the color of the button), Caption (the text on the button), Font (change the format of the text).
11. Once your done, close the adjusting window and right click the button again and now select View code.
12. 2 lines are already given. Paste the line below between the 2 lines:
13. Back at Excel, have a look at the Developers ribbon and next to Insert you will find Design mode. Click it so it is not selected anymore.
Now you can click your button to clear the contents of range A1:T15.
Hopefully my explanation/directions are easy to follow.