Hello everyone,
I have some troubles with conditional formatting, see example below:
<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>
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>