Hi,

I have been trying to get all the cells in a row to change from one
background colour to another dependent upon the the last cell in the row
containing the word "Yes".

So for example, all cells in all rows are green. But when the last cell in
say row 5 contains the word "Yes" all the cells in row 5 need to change to
yellow.

I have managed this on a row by row basis by selecting all cells in a row
and using conditional formatting with formula =$I$1="Yes" on row 1,
=$I$2="Yes" on row 2 etc etc.

I have 1000 rows and I don't want to have to enter this on a row by row
basis so unless someone knows how to get conditional formatting to increment
the "$I$1" to "$I$2" etc I need another fix...

Thanks