Thank you for your reply to my thread. Sorry for the confusion. Hopefully this additional input from me will make things more clear.

First step is to clear all colors from rows within a range starting at cell A8 and ending at the last row which contains data in column A

To address your questions...
The last row could be A9 or A255, A355 or beyond...depending on how many total rows with data are in column A of the spreadsheet.

My statement "above row 8" is in reference to any row number above 8. My intention is to have the macro function for all rows except rows 1 through 7.

The row to be colored is to be determined by selecting a cell (Active Cell) in the row (any row except for rows 1 through 7) that I wish to be colored yellow.