Possibility conditional formatting within range of cells

[Kick4s]

Hello everyone,

I have some troubles with conditional formatting, see example below:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]
[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]25-Aug-2019[/TD]
[TD]26-Aug-2019[/TD]
[TD]27-Aug-2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]activity1[/TD]
[TD]8[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]activity2[/TD]
[TD]
[/TD]
[TD]8[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]activity3[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

My goal is to change the colour of the "activity" cell when:

"B2 to D2 is not blank

and

date B1 to D1 has expired"

From my understanding, the (start of the) formula should be:
= AND (NOT (BLANK (B2) ) ; B1<today ()="" )<today())<today="" ())<today())<today())"<today())<today())".="" but="" this="" formula="" only="" takes="" one="" cell="" in="" account.=""
< TODAY () )<today())


Is it possible to make this work with a range of cells without having to put in multiple conditional formats?

I work with the Dutch version of Excel 2010 so ';' and ',' are different than the international version, I will clarify more if needed.

Many thanks in advance!</today())
</today>

 

[Fluff]

This is what I get with that formula

Book1
	A	B	C	D
1	date	28-Aug-19	29-Aug-19	30-Aug-19
2	activity1	8
3	activity2		8
4	activity3			8
End

The only way I can get it to highlight A3 & A4 is if B3 & B4 are not completely blank.

 

[Kick4s]

I have (also) tried it in a new Excel sheet, there it works like it should...

Maybe there is indeed something wrong with the sheet I am working with (non-blank cells which interfere with the formula or other conflicting formulas that are unknown to me).

What are other things I should keep in mind of within the sheet, regarding the (strangely) not working formula?

 

[Joe4]

I would check/confirm that those cells really are empty.
What does these formulas return?
=LEN(B3)
=LEN(D3)

If they both do not return 0, then there is something in there (maybe a space or some other invisible character).
A lot of times, data copied or downloaded from the Web or other applications often have "inivisible" characters.

 

[Fluff]

Another thing to try is using
=ISBLANK(B3)
If you have copy/pasted as value formulae that return "" the length will be 0, but isblank will return false.

 

[Kick4s]

I would check/confirm that those cells really are empty.
What does these formulas return?
=LEN(B3)
=LEN(D3)

If they both do not return 0, then there is something in there (maybe a space or some other invisible character).
A lot of times, data copied or downloaded from the Web or other applications often have "inivisible" characters.

Hi Joe4,

Thanks for the feedback, I will try this out.

 

[Kick4s]

Another thing to try is using
=ISBLANK(B3)
If you have copy/pasted as value formulae that return "" the length will be 0, but isblank will return false.

I will try this also, wish me luck!

 

[Fluff]

Fingers crossed