Hi,
I have a sheet with data in Columns D to O & P starting from row 12. I want to conditionally format each row for columns D to O with a Green-Yellow-Red colour scale if the value of Column P (same row) is 1, else if the value is zero, no conditional formatting should be applied. I want each row formatted individually & I want the macro to recognise when it has reach the bottom of the sheet (column P will be blank at row 156) and stop running.
Bookmarks