Highlight Excel Cells When Two Date Columns are Overdue
Question details
The user needs to highlight cells in a specific column when the dates in either of two other columns have passed the current date.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Tracking project deadlines or overdue tasks across multiple date columns.
- Observed behavior
- The user wants a conditional formatting rule that evaluates actual date values instead of relying on whether another cell is visually colored.
Ensure your date columns are formatted as actual dates rather than text strings so the TODAY() function can accurately compare the values.
Use OR and AND Functions in Conditional Formatting
Create a custom formula rule to evaluate if either of the two date cells is not blank and is less than today's date.
To evaluate multiple conditions across different columns, you can combine the OR and AND logical functions within a single conditional formatting rule. This ensures that the cell is only highlighted if a valid date exists and that date is strictly in the past.
Highlight the cells in your target column (e.g., Column X, starting from X2) where you want the formatting to appear.
Navigate to the Home tab on the Excel ribbon, click on 'Conditional Formatting', and choose 'New Rule' from the dropdown menu.
Select 'Use a formula to determine which cells to format'. In the formula box, enter: =OR(AND(V2<>"",V2<TODAY()),AND(W2<>"",W2<TODAY())). Adjust V2 and W2 to match the first row of your actual date columns.
Click the 'Format' button, switch to the 'Fill' tab, choose a highlight color (like red or yellow), and click 'OK' twice to apply the new rule.

Manage Overdue Dates Easily with WPS Spreadsheet
WPS Spreadsheet provides robust conditional formatting tools that are completely compatible with Excel formulas, allowing you to highlight overdue dates, manage project deadlines, and streamline your workflow effortlessly.
- 1. Open your worksheet: Launch WPS Spreadsheet and open the file containing your date columns.
- 2. Select the column: Highlight the column where you want the conditional formatting to appear (e.g., Column X).
- 3. Apply Conditional Formatting: Go to the Home tab on the top menu, click 'Conditional Formatting', and select 'New Rule'.
- 4. Input the formula: Choose 'Use a formula to determine which cells to format', input =OR(AND(V2<>"",V2<TODAY()),AND(W2<>"",W2<TODAY())), configure your highlight color, and click OK.

Frequently Asked Questions
Why is conditional formatting highlighting my blank cells as overdue?
Excel interprets completely blank cells as a zero value, which corresponds to January 0, 1900. Because this date is far in the past, it evaluates as less than TODAY(). Adding the condition V2<>"" inside your AND function ensures blank cells are ignored.
Can I apply this conditional formatting rule to highlight the entire row instead of just one column?
Yes. Simply select your entire data range (e.g., A2:Z100) instead of just Column X. When entering your formula, lock the column references with a dollar sign: =OR(AND($V2<>"",$V2<TODAY()),AND($W2<>"",$W2<TODAY())). This applies the check across the whole row.
How do I change the color of the highlighted cells later?
Navigate to Home > Conditional Formatting > Manage Rules. Select your existing rule from the list, click 'Edit Rule', and then click the 'Format' button to choose a new fill color or font style.




