Sep 28 2022 06:58 AM
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 |
Sep 28 2022 07:07 AM
Attached is a working example. The image here shows the formula in the Conditional Formatting dialog box.
Sep 28 2022 07:09 AM
SolutionSep 28 2022 07:12 AM
Sep 28 2022 07:09 AM
Solution=COUNTIF($B$2:$B$6,"L")>0
This is the rule for conditional formatting in the example.