conditional formatting

[girth69]

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

[Carim]

Hi,

Yes ... it is feasible ...
Format Conditional Formatting
Formula Is
=$E$2="Yes" ( adjust to your validation cell )
Format Patterns Red
Ok

Then format Painter to all the other cells ...

HTH
Carim