Forum Discussion

SCOTT4242's avatar
SCOTT4242
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's avatar
    OliverScheurich
    Sep 28, 2022

    SCOTT4242 

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

    This is the rule for conditional formatting in the example.

mathetes's avatar
mathetes
Silver Contributor
Sep 28, 2022

SCOTT4242 

 

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

 

Resources