Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 =E2-TODAY() but I'm not sure if this can be incorporated. Thank you!!

share|improve this question

1 Answer 1

In Excel 2007 this worked for the Conditional Formatting formula.

=(TODAY()-$A2)<5

To only include the five days leading up to today (if you have dates in the future):

=AND((TODAY()-$A2)<5,(TODAY()-$A2)>-1)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.