Conditionally Formatting if another column contains a specific date
Solved/Closed
cjf15
-
26 May 2021 à 15:45
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2021 à 12:07
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2021 à 12:07
Related:
- Conditional formatting based on date in another cell
- Excel conditional formatting based on date - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
- Excel clear formatting - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
27 May 2021 à 12:07
27 May 2021 à 12:07
Hi cjf15,
The due date being next month or being passed will fit in the same condition:
MONTH($B2)<=MONTH(TODAY())+1
To NOT highlight the row when the corresponding cell in column B is empty (so you can apply the CF to rows which don't contain a due date yet):
$B2<>""
To ONLY highlight the row when the corresponding cell in column I is empty:
$I2=""
We then combine the above in an AND formula:
=AND(MONTH($B2)<=MONTH(TODAY())+1,$B2<>"",$I2="")
Best regards,
Trowa
The due date being next month or being passed will fit in the same condition:
MONTH($B2)<=MONTH(TODAY())+1
To NOT highlight the row when the corresponding cell in column B is empty (so you can apply the CF to rows which don't contain a due date yet):
$B2<>""
To ONLY highlight the row when the corresponding cell in column I is empty:
$I2=""
We then combine the above in an AND formula:
=AND(MONTH($B2)<=MONTH(TODAY())+1,$B2<>"",$I2="")
Best regards,
Trowa
