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
)