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

W

CHIEFSL
BENGALSL
COWBOYSW
GIANTSW

 

 

 

Resources