Forum Discussion
Conditional Formatting - IF AND
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
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.
Thank you for catching that, I meant to say column I not H for current or past due.
