Button that automatically fills row?

[Battletoads]

I have a table that has demographic info (name, DOB, address, etc.) that I have to manually enter into another program. Is there a way, with a button or anything, that I can automatically fill the next row with color when I finish entering it? What i'm looking for is, when I finish uploading row 1, a button I can press that fills the whole row 1 with colour or something so that when I look at row 2, I don't inadvertently upload information from row 1 (since it will be a different colour), then I press the button again and it fills row 2 and so on and so forth, since I am just going consecutively down the table and uploading the information. Currently, manually highlighting and filling takes too long. If anyone has another suggestion though, I would gladly appreciate it.

Edit: Almost immediately after posting this, I found a workaround using conditional formatting, issue solved

[MrNoob93]

Hello Battletoads,

Assuming your issue requires highlighting rows for which the required data has already been entered, carry out the following steps:

1. Identify the range of cells you will need to enter the data for i.e the number of line items for which information has to be entered.

2. Go to Home -> Conditional Formatting -> New Rule [Shortcut : Alt - H - L - N]

3. Choose "Format only cells that contain" under "Select a new rule".

4. Edit the rule description to Cell value - not equal to - "" (Indicating the cell value equal to a blank cell)

5. Head to "Format" option in the same window. Select the "Fill" tab and pick a color of your choice to highlight the cells.

6. Click OK to save the new formatting rule and your highlighting process should be streamlined.

Have a fabulous day. Cheers!