I would like to colour the background of a row in Google Spreadsheets:
For example:
If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black.
If cell Dx = title 'closed' the font colour of cell Ax to Nx turns green.
I can do this in Excel quite easily...