I have a spreadsheet, cells A1 to D100 are active. If D1 contains a figure I want the whole A1:D1 to change to green. I can do this, no trouble, conditional formating ...