Forum Discussion
Changing cell color based on content of multiple cells in a ROW
Example: Cell A1 is colorless when B1 contains a value less than 1.49, cell C1 does not contain "H" and cell D1 does not contain "SB". Cell A1 turns light green when any one of the three cells conta...
HI David,
Create 3 conditional formatting rules for each color applied to A1 compare the formula below with 1, 2 and 3. For first rule (any one) that could be
=SUM(B1>=1.5,COUNTIF(C1,"*H*")>0,COUNTIF(D1,"*DB*")>0)>=1
Place "all three" rule on first place, after that "any two" and "any one" is very down.