Home

Conditional Formatting - IF AND

CourtneyC
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

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies