Hi,

I have 4 columns of data and in the 5th column i have a validation box with a simple Yes / No list in it. What i want is for when you select the box in the 5th column to Yes, for the entire row of data to turn Red. Is it possible to do this with conditional formatting??
The information in the rows is all typed in data without any formulas.

cheers