Guys,

No idea why this wont work because I've done conditional formatting so much in past projects at work, but I'm trying to set something up for my dad which is a basic spreadsheet of invoices, however the last column is 'paid' and I want to set conditional formatting to say when paid = Y then highlight the whole row as grey for example, but it will only change the cell with the Y in grey - any idea's what I'm missing as sure this is how I used to do it in the past.

Thanks