On Fri, 21 Oct 2005 17:36:35 -0500, Jonibenj
wrote:


What goes in the brackets after 'TODAY'? I can't make this work!
:(

Nothing goes in the brackets after TODAY().

I don't know what you mean by "can't make this work".

Let me lead you through it step by step.

Try this on a new sheet:

A1: 1 Sep 2005

With A1 still selected, from the main menu select

Format/Conditional Formatting

In the first box of this dialog box select
Cell Value Is

In the adjacent box select
Less than

In the next adjacent box, enter the formula
=TODAY()-30

Then select Format
On the Font Tab select Bold; and the color Red

Then
OK
OK
should close the box and you should see A1 formatted in bold red.

You should be able to adapt this process to fit your needs. As written, the
cell contents will become RED and BOLD if the date in the box is more than 30
days before today. So if the date represents the DATE DUE, then it will turn
red when it is 30 days old.

Obviously you can change the condition if you want it flagged for other
circumstances.


--ron