Possibility conditional formatting within range of cells

[Kick4s]

Hello everyone,

I have some troubles with conditional formatting, see example below:

	A	B	C	D
1	Date	25-Aug-2019	26-Aug-2019	27-Aug-2019
2	activity1	8
3	activity2		8
4	activity3			8

<tbody>
</tbody>

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