I created a simple spreadsheet with products and their expiration dates. I want 3 colorings green for products that expire in today()+15days, yellow for products that expire in the next 15 days and red for expired products. I want the whole row to be colored.
No problem with expired products: $D2< TODAY() and
products that not expire in the next 15 days: $D2 > TODAY()+15
I have 2 problems:
- Also empty rows are marked as expired:red. What should I add in the formula to not mark red empty rows?
- I did not manage to create the middle category: products that have not expired, but will expire in the next 15 days.
Thank you!!