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 contain the following; B1 contains a value equal to or greater then 1.5 or C1 contains "H" or cell D1 contains "SB".
Cell A1 turns darker green when any two of the three cells meet their specific condition.
Cell A1 turns darkest green when all three cells meet their specific condition.
Thank you,
Dave
1 Reply
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.
