Forum Discussion

Copper Contributor

Sep 28, 2022

Solved

Conditional Formatting single Cell based on multiple cells

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...

excel

Formulas and Functions

OliverScheurich
Sep 28, 2022
SCOTT4242
=COUNTIF($B$2:$B$6,"L")>0
This is the rule for conditional formatting in the example.

mathetes

Silver Contributor

Sep 28, 2022

Nice. More efficient than my OR formula.

SCOTT4242

Copper Contributor

Sep 28, 2022

THANK YOU!