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)

• excel

Share Improve this question Follow asked Feb 3 at 5:07 ChrisChris 2944 bronze badges 2

• 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="")