Hi Galsaba,
Consider using Conditional Formatting.

See Debra Dalgleish's CF tutorials at:

http://www.contextures.com/xlCondFormat01.html

---
Regards,
Norman



"Galsaba" wrote in message
...
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

)