Comparing dates in cells to a specified date and changing cell colours to match!! HELP!!

[saj726]

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

 

[VoG]

You should be able to do this using Conditional Formatting. There is an example here http://www.contextures.com/xlCondFormat03.html#Expiry

 

[saj726]

Thank you..
I'll check it out!!!

THanx again!!!