Problem: Check if dates are within seven days from today. If so, make font bold.

(The first date is today)

Solution:

  1. Select the dates
  2. Click conditional formatting
  3. Use formula "=AND(B1>TODAY(),B1<TODAY()+7)
  4. Click "Format..." button
  5. Click "Bold" in font style
  6. Press ok!

Dates within 7 days from today (2007-10-24) are bold.