Feb 20 2019 03:44 PM - edited Feb 21 2019 07:22 AM
Hello everyone,
I am trying to create several conditions for an Excel I am working on but I am struggling to make them work.
UPDATE: I meant to say put past due or current in column I not H.
Could anyone assist me with this? Thank you
Feb 20 2019 04:44 PM
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.
Feb 21 2019 07:20 AM
Thank you for catching that, I meant to say column I not H for current or past due.