Dave,

This is great!
How can I make all rows having the same format?

Thanks,

galsaba

Dave Peterson wrote:
You could avoid typing the =today() in all those cells and bury it in
your
formula:

=if(today()x2,"overdue","")

Then take a look at Format|conditional formatting

You can change the color or the row based on the value in one column.

With rows 2:xxxx selected and row 2 the row with the active cell:
use Formula is:
=$b2="overdue"

(if column B held the warning)


Galsaba wrote:

I have a spreadsheet that have two columns: 1. Task 2. Due date
I wanted to have an easy indication to see what tasks (rows) are
overdued.
To do so I created two more columns: 3. Today Date 4. Overdue?
In column #3 I typed today() in all rows. In Column 4 I typed: =If
(X3X2,
"Overdue","").
In this case whenever I have task which is overdue, automatically
field 4 will
read "Overdue"

Can I make a Macro or VB Script that in addition to the above the
whole row
will be highlighted (let's say green).

Thanks,

galsaba

)

--

Dave Peterson