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!