你的位置：首页>programmer>Using Excel rules, what formula I can use to highlight a cell based on two different cells - Stack Overflow

Using Excel rules, what formula I can use to highlight a cell based on two different cells - Stack Overflow

What formula can I use in rules that can accomplish the following:

If there’s text on E2 and D1 its BLANK, then Cell C1 will be highlighted green

Something similar to this. =COUNTIFS(E2:E6, TRUE, B:B, B1, B:B, 0)

What formula can I use in rules that can accomplish the following:

If there’s text on E2 and D1 its BLANK, then Cell C1 will be highlighted green

Something similar to this. =COUNTIFS(E2:E6, TRUE, B:B, B1, B:B, 0)

Share Improve this question asked Feb 3 at 5:07 Chris 294 bronze badges

Try =AND(ISTEXT(E2),D1=""). Or =(E2<>"")*(D1=""). – Harun24hr Commented Feb 3 at 5:11
=(E2<>"")*(D1="") worked like a charm! Thank you. – Chris Commented Feb 3 at 5:53

Add a comment |

1 Answer 1

Sorted by: Reset to default 2

In CF rule, custom formula field put the following formula-

=(E2<>"")*(D1="")