Excel colour help

Hi all,

I have a spreadsheet as below (i've blanked out the names in column A relating to staff)

I would like the spreadsheet to be formatted so that if there is any text in rows B9-AD9, B10-AD10 and B11-AD11 then the corresponding cell in row 17 turns orange.

I would also then like it that if we put text in that orange cell, that it goes back white. is that something I can do?

The information going in to the B9-AD9 etc rows will be put in manually. Thank you!