SOLVED

Conditional Formatting if notblank & blank same formula

Copper Contributor

Good morning,

 

Trying to create a conditional formatting rule, that if:

 

Cell B6 is NOTBLANK but Cell L6:N6 is BLANK if should highlight the cells.

 

I've tried different forumlas, but unable to use & as its a conditional formula rule.

 

Any idea's, or something I'm missing?

 

Thanks.

1 Reply
best response confirmed by AaronL89 (Copper Contributor)
Solution

@AaronL89 

Try

=AND($B6<>"",COUNTBLANK($L6:$N6)=3)

1 best response

Accepted Solutions
best response confirmed by AaronL89 (Copper Contributor)
Solution

@AaronL89 

Try

=AND($B6<>"",COUNTBLANK($L6:$N6)=3)

View solution in original post