Conditionally Formatting if another column contains a specific date
Solved/Closed
cjf15
-
May 26, 2021 at 03:45 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2021 at 12:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 27, 2021 at 12:07 PM
Related:
- Conditionally Formatting if another column contains a specific date
- Excel date format dd.mm.yyyy - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If a cell contains any text then add a value ✓ - Excel Forum
- Vba find column by name ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Updated on May 27, 2021 at 12:10 PM
Updated on May 27, 2021 at 12:10 PM
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
