Conditional Formatting

[Kidsty Pike]

Hi All

I wish to apply conditional formatting to cell B3

If the cells in range C3:F3 *all* contain "Yes"
then the condition is true.

If any of the cells is blank, then the condition is false.

How do I word the formula?

Many thanks.

Kidsty.

 

[Alan]

One Way,
=COUNTIF(C1:F1,"Yes")=4

 

[Guest]

Alan

Brilliant!

Thanks very much.
Next time I would like a quicker response! <VBEG>

Kidsty