I work at a petrol station/mini market and I'm setting up a system on pc where basically, you enter the expirary dates of the products and excel compares them to todays date (by either button of automatically when loaded)...
From here. i'm trying to make it so that the cells remain normal if they are in ddate.. but then closer to the expirary date they change from yellow, to orange to red.. like every 2 weeks leading up to expirary date.
Im sorry if this has been answered previously, just im getting frustrated with my attepmts.
Thank you to anyone who reads this
Regards
Scott
From here. i'm trying to make it so that the cells remain normal if they are in ddate.. but then closer to the expirary date they change from yellow, to orange to red.. like every 2 weeks leading up to expirary date.
Im sorry if this has been answered previously, just im getting frustrated with my attepmts.
Thank you to anyone who reads this
Regards
Scott