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!
