Highlight Multiple Cell When Condition Meet

[cyliyu]

I want to highlight C1 to C8 at R3 and R6 only when the whole rows are with the word blank.
What should be the formula to use?
I used

=AND(D8="blank",E8="blank",F8="blank",G8="blank",H8="blank",I8="blank",J8="blank",K8="blank")

and it only hightlight the 1st cell.
Thanks.

 

[bosco_yip]

Select D6:K11 >> Conditional formatting >> new rule >> Use a formula…... >> In the rule box enter :

=AND($D6="blank",$E6="blank",$F6="blank",$G6="blank",$H6="blank",$I6="blank",$J6="blank",$K6="blank")

>> Choose "blue" color fill >> OK >> Finish

Regards

 

[vletm]

cyliyu
use for formula =COUNTIF($A6:$K6,"blank")=8

 

[Khalid NGO]

Hi,

One more:

=AND($D$8:$K$8="Blank")

Regards,

 

[cyliyu]

Thanks All,
All the 3 formulas work as per expected.