SOLVED

Conditional Formatting single Cell based on multiple cells

Copper Contributor

How do I formal Cell A1 based on information from Cells B2, B3, B4, B5, B6?

 

I want to Fill Cell TEAM w/Red if at least one of the cells B2, B3, B4, B5, B6 Contain "L"

 

TEAM 1 
PATRIOTS

W

CHIEFSL
BENGALSL
COWBOYSW
GIANTSW

 

 

 

4 Replies

@SCOTT4242 

 

Attached is a working example. The image here shows the formula in the Conditional Formatting dialog box.

mathetes_0-1664373990149.png

 

best response confirmed by mathetes (Silver Contributor)
Solution

@SCOTT4242 

=COUNTIF($B$2:$B$6,"L")>0

This is the rule for conditional formatting in the example.

cf.JPG

Nice. More efficient than my OR formula.
1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution

@SCOTT4242 

=COUNTIF($B$2:$B$6,"L")>0

This is the rule for conditional formatting in the example.

cf.JPG

View solution in original post