---
title: "Overdue and unpaid | PracticeExcel"
description: "Practice conditional formatting with two conditions in Excel. Highlight overdue, unpaid invoices with AND and get the formula checked right away."
canonical_url: "https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices"
locale: en
meta:
  "og:description": "Practice conditional formatting with two conditions in Excel. Highlight overdue, unpaid invoices with AND and get the formula checked right away."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Overdue%2Band%2Bunpaid%2Cdescription_~UHJhY3RpY2UgY29uZGl0aW9uYWwgZm9ybWF0dGluZyB3aXRoIHR3byBjb25kaXRpb25zIGluIEV4Y2VsLiBIaWdobGlnaHQgb3ZlcmR1ZSwgdW5wYWlkIGludm9pY2VzIHdpdGggQU5EIGFuZCBnZXQgdGhlIGZvcm11bGEgY2hlY2tlZCByaWdodCBhd2F5Lg%2Ceyebrow_Conditional%2Bformatting%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJJbnZvaWNlIiwiRHVlIiwiUGFpZCIsIlJ1bGUiXX0seyJuIjoyLCJjZWxscyI6WyIxMDQzIiwiT2N0IDI3LCAyMDI2IiwiTm8iLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9jb25kaXRpb25hbC1mb3JtYXR0aW5nL292ZXJkdWUtdW5wYWlkLWludm9pY2VzIg%2Cs_CJKgJhLVkJVGmlLo.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Overdue and unpaid | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Overdue%2Band%2Bunpaid%2Cdescription_~UHJhY3RpY2UgY29uZGl0aW9uYWwgZm9ybWF0dGluZyB3aXRoIHR3byBjb25kaXRpb25zIGluIEV4Y2VsLiBIaWdobGlnaHQgb3ZlcmR1ZSwgdW5wYWlkIGludm9pY2VzIHdpdGggQU5EIGFuZCBnZXQgdGhlIGZvcm11bGEgY2hlY2tlZCByaWdodCBhd2F5Lg%2Ceyebrow_Conditional%2Bformatting%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJJbnZvaWNlIiwiRHVlIiwiUGFpZCIsIlJ1bGUiXX0seyJuIjoyLCJjZWxscyI6WyIxMDQzIiwiT2N0IDI3LCAyMDI2IiwiTm8iLCIiXX1dLCJ0YXJnZXQiOlsxLDNdfX0%2Cp_Ii9wcmFjdGljZS9jb25kaXRpb25hbC1mb3JtYXR0aW5nL292ZXJkdWUtdW5wYWlkLWludm9pY2VzIg%2Cs_CJKgJhLVkJVGmlLo.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **Overdue and unpaid**

**Premium**

Highlight the invoice when it is overdue and unpaid. In D2, write the rule with AND. The due date in B2 must be before G1, and C2 must say "No". Lock the columns and all of G1.

D2fx

|  | A | B | C | D | E | F | G | H |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | Invoice | Due | Paid | Rule |  | Today | Nov 2, 2026 | |
| 2 | 1043 | Oct 27, 2026 | No |  |  |  |  | |
| 3 |  |  |  |  |  |  |  | |
| 4 |  |  |  |  |  |  |  | |
| 5 |  |  |  |  |  |  |  | |
| 6 |  |  |  |  |  |  |  | |
| 7 |  |  |  |  |  |  |  | |
| 8 |  |  |  |  |  |  |  | |

**Premium lesson**

## **Unlock Conditional formatting and every other lesson**

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:**Drop-down lists and data validation****COUNTIF**

[**See plans, from $5/month**](https://practiceexcelonline.com/pricing) [**Already premium? Sign in**](https://practiceexcelonline.com/login?next=/practice/conditional-formatting/overdue-unpaid-invoices)

Need help?

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices#webpage","@type":"WebPage","description":"Practice conditional formatting with two conditions in Excel. Highlight overdue, unpaid invoices with AND and get the formula checked right away.","name":"Overdue and unpaid","url":"https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices","breadcrumb":{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"Conditional formatting","item":"https://practiceexcelonline.com/practice/conditional-formatting","position":3},{"@type":"ListItem","name":"Overdue and unpaid","position":4}]},{"@id":"https://practiceexcelonline.com/practice/conditional-formatting/overdue-unpaid-invoices#/schema/learning-resource/1","@type":"LearningResource","description":"Practice conditional formatting with two conditions in Excel. Highlight overdue, unpaid invoices with AND and get the formula checked right away.","educationalLevel":"intermediate","isAccessibleForFree":false,"learningResourceType":"exercise","name":"Overdue and unpaid","teaches":"Conditional formatting"},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.