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...
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.
