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...
How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?
google spreadsheets;conditional formatting