Create If statement based if cell above is occupied

I would like to write a if statement in excel that is based off the cell above being occupied. A create a photo and it is below of what I am looking for. The if statement should be if any cell is occupied the cell below it should be colored red. Just like in the image below.