Hi excel.jpg

I have a formula in cell A5 that either returns the text "Supply number 2" or leaves the cell blank. I have to have the spreadsheet set up so it changes the fille colour based on if the cell is blank or has the text in it. Please can you help

Thanks