Conditional formatting in Excel 07
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 :)