due dates

  • Thread starter Thread starter canman
  • Start date Start date
C

canman

I'm probably missing something
here is what I'm doing
Formula 1 =F5:F60=
Formula 2 =MONTH(TODAY())=MONTH(F5:F60)
Formula 3 =TODAY()>F5:F60

above is the actual typing I am placing in the formula box
thanks for any help
the "F" column contains due dates for recerts for aprox 55 people fro
F5 down to F6
 
Hi, try these steps *exactly* to get it up:

Select F5:F60
(This selection step is important!)

Click Format > Conditional Formatting

Make these settings:

Condition 1
Formula Is | =F5=""
Leave it as "No format set"

Click Add >> (this adds condition 2)

Condition 2
Formula Is | =MONTH(TODAY())=MONTH(F5)
Click Format button > Patterns tab > Yellow? > OK

Click Add >> (this adds condition 3)

Condition 3
Formula Is | =TODAY()>F5
Click Format button > Patterns tab > Pale red? > OK

Click OK at the main dialog
 
Back
Top