Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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):

share|improve this answer

Your Answer


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.