Conditional Formatting - IF AND

Highlighted
Occasional Contributor

Hello everyone,

 

I am trying to create several conditions for an Excel I am working on but I am struggling to make them work.

  • If column J is "3" and column H has a date that is 2 years old, then put "Past Due" in column I
  • If column J is "2" and column H has a date that is 1 years old, then put "Past Due" in column I
  • If column J is "3" and column H has a date that is less than 2 years old, then put "Current" in column I
  • If column J is "2" and column H has a date that is less than 1 years old, then put "Current" in column I
  • If Column I is "Past Due" highlight column I and column A

UPDATE: I meant to say put past due or current in column I not H.

Could anyone assist me with this? Thank you

2 Replies
Highlighted

See if this helps. You cannot have a formula or conditional formatting change a cell's value, so if H has the date, it cannot have "current" or "past due." So I put those in a separate column. You could hide the date if desired, but it would make it difficult for someone to input data.

Highlighted

Thank you for catching that, I meant to say column I not H for current or past due.