Forum Discussion
SCOTT4242
Sep 28, 2022Copper Contributor
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 |
CHIEFS | L |
BENGALS | L |
COWBOYS | W |
GIANTS | W |
- OliverScheurichGold Contributor
- mathetesSilver Contributor
Attached is a working example. The image here shows the formula in the Conditional Formatting dialog box.