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.

Additional attempt for clarification of what I am hoping to accomplish.
I want to be able to change the color of a row in my spreadsheet to yellow. I want to select that row by selecting a cell in the row that I want to be colored yellow. This is to include all rows that have contiguous data in column A, excluding rows at 1 through 7. (Starting with row at A8 plus all additional rows numbered higher than row A8 that contain data...till a blank is encountered in column A).
In addition to my original inquiry, I would also like to limit this activity to columns A thru BZ.
Before I have the color of the desired row changed to yellow, I want to have any colors removed from all rows , except for rows 1 through 7.