Forum Discussion
SeanC3
Oct 20, 2021Copper Contributor
Excel Formula Help - Conditional Formatting a cell based on specific text in two other cells
Hi team, I am hoping someone can assist in figuring out a formula that will allow me to quickly audit a large amount of data. Ideally I need to conditional format a cell (C1) only if (A1) contai...
Riny_van_Eekelen
Oct 20, 2021Platinum Contributor
SeanC3 Example attached! Used two separate rules. One for "Home" in A AND "not a number" in B. The other checks for "Away" in A AND "a number" in B.