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