So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out?
I have a formula that counts down the days =E2TODAY()
but I'm not sure if this can be incorporated. Thank you!!
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.



In Excel 2007 this worked for the Conditional Formatting formula.
To only include the five days leading up to today (if you have dates in the future):


