Share via

Conditional formatting rule required for overdue date

Anonymous
2024-03-04T12:49:36+00:00

Hi there

If column A is the date - I need to format the row red if the date is older than 14 days.

However, if certain text is in column I then I want the whole row to revert back to its original formatting.

Is this possible? I can action these separately but fall down when combining them.

Many thanks

Bec

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-03-04T13:10:18+00:00

=A2+14<TODAY()

Image

=AND(A2+14<TODAY(),C2<>"A")

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-04T17:19:39+00:00

    Thank you! That's really helpful.

    Was this answer helpful?

    0 comments