due dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

canman - 22 Sep 2004 11:59 GMT

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

Reply to this Message

Max - 22 Sep 2004 12:33 GMT

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
--
Note that formula settings are made using *only*
the first cell in the range selected, i.e.: F5

It should work ok now ..

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

>
> I'm probably missing something
[quoted text clipped - 13 lines]
> canman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14596
> View this thread: http://www.excelforum.com/showthread.php?threadid=262235

Reply to this Message