Hi All,
I have a spreadsheet that i have made, but i am having trouble setting up 1 conditional format.
I have 2 set up already, so that when the cell has Suspended in the cell it then highlights that cell red, and i have a count at the top which counts how many cells have Suspended written in it.

How can i set it up that when the cell has Suspended written in it, it fills the row red and not just the cell?

Any help would be great

Thanks