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-...