-1

I was wondering how would i through VBA conditionally format the whole row or a row in a range based on the first cell in that row? Also it would require a comparison to the previous row to current row (first cell value) and format it as per its results? I know how to do it with cells but rows in a range has me stumped. Also i already have a search criteria within conditional formatthing.

1 Answer 1

1

You know how to do it will cells in a range, you just append the .entirerow to the end of the range e.g.-

Cells(1,1).EntireRow.Interior.Color = 6

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .