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 ChrisChris 294 bronze badges 2 |1 Answer
Reset to default 2In CF rule, custom formula field put the following formula-
=(E2<>"")*(D1="")
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1745248775a4618549.html
=AND(ISTEXT(E2),D1=""). Or=(E2<>"")*(D1=""). – Harun24hr Commented Feb 3 at 5:11